| 0.0002 |
SELECT `apc`.`super_admin_only_YN`
FROM (`application_components` apc)
WHERE `apc`.`Module_Name` = 'publications'
AND `apc`.`control_Name` = 'publications'
AND `apc`.`Function_Name` = 'browse'
|
| 0.0002 |
SELECT DISTINCT `ipm`.`Application_component_id` as apc_id, `apc`.`id` as apc_id, `apc`.`External_Name`, `apc`.`Internal_Name`, `apc`.`Module_Name` as module_name, `apc`.`control_Name` as control_name, `apc`.`Function_Name` as function_name, `apc`.`default_function_YN`, `apc`.`required_login_YN`, `apc`.`Tab_Id`, `apc`.`ComponentType_Id`, `apct`.`Name` AS app_component_type_Name, `apc`.`SecurityType_Id`, `st`.`Name` AS security_types_Name, `apc`.`Parent_Id`, `apc`.`ActionType_Id`, `at`.`Name` AS action_type_Name
FROM (`internalrole_permission_matrix` ipm)
JOIN `internal_roles` inr ON `inr`.`ID` = `ipm`.`Internal_Role_id`
LEFT JOIN `role_internalrole_reln` rir ON `inr`.`ID` = `rir`.`internal_role_Id`
LEFT JOIN `role` r ON `r`.`ID` = `rir`.`role_Id`
JOIN `application_components` apc ON `apc`.`ID` = `ipm`.`Application_component_id`
JOIN `application_component_types` apct ON `apct`.`ID` = `apc`.`ComponentType_Id`
JOIN `security_types` st ON `st`.`ID` = `apc`.`SecurityType_Id`
JOIN `action_type` at ON `at`.`ID` = `apc`.`ActionType_Id`
WHERE `r`.`machine_name` = 'guest_user'
AND `apc`.`super_admin_only_YN` = 'N'
ORDER BY `ipm`.`Application_component_id`
|
| 0.0364 |
SELECT DISTINCT SQL_CALC_FOUND_ROWS NULL AS found_rows, ep.ID AS publication_id, ep.Name AS publication_name, ep.Author AS author, ep.Description AS description, ep.Published_by AS publisher, ep.Private_YN AS access, ep.exam_category_id, ep.ISBN_NO AS ISBN, IF(ep.mark_new_until_date >= CURDATE( ), "Y", "N" ) AS new_test, ec.Name AS exam_category_name, i.Name AS publication_logo_name, COUNT(DISTINCT if(c.Inactive_YN ="N", epc.Container_Id, NULL)) AS total_tests, (SELECT
count(DISTINCT c.ID)
FROM
containers c
INNER JOIN exams e1 ON (c.Exam_Id = e1.id)
INNER JOIN exam_publication_containers epc1 ON (epc1.Container_Id = c.ID)
INNER JOIN user_test_info uti2 ON (uti2.Test_id = epc1.Container_Id)
WHERE
epc1.exam_publication_Id = ep.ID AND uti2.Favorite_YN = "Y" AND uti2.User_id = -1) AS my_test_count, (SELECT DISTINCT Favorite_YN FROM user_test_info uti3 WHERE uti3.Publication_id = ep.ID AND User_id = -1) AS Favorite_YN
FROM (`exam_publication` ep)
INNER JOIN `exam_category` ec ON `ep`.`exam_category_id` = `ec`.`ID`
INNER JOIN `exam_publication_containers` epc ON `ep`.`ID` = `epc`.`exam_publication_Id`
INNER JOIN `containers` c ON `epc`.`Container_Id` = `c`.`id`
LEFT JOIN `user_test_info` uti1 ON `uti1`.`Publication_id` = `ep`.`ID`
LEFT JOIN `images` i ON `ep`.`Image_id` = `i`.`ID`
WHERE `ep`.`exam_category_id` = '46'
AND `ep`.`Inactive_YN` = 'N'
AND ((uti1.Favorite_YN = "Y" AND uti1.User_id = -1) OR ep.Private_YN = "N")
GROUP BY `ep`.`id`
ORDER BY `ec`.`ID`, `ep`.`sort_order` asc
LIMIT 10
|
| 0.0002 |
SELECT FOUND_ROWS() AS count;
|
| 0.0002 |
SELECT `ec`.`id` AS exam_category_id, `ec`.`name` AS exam_category_name
FROM (`exam_category` ec)
INNER JOIN `exams` e ON `ec`.`id` = `e`.`exam_category_id`
WHERE `ec`.`InActive_YN` = 'N'
GROUP BY `ec`.`id`
ORDER BY `exam_category_name` asc
|
| 0.0358 |
INSERT INTO `debug_log` (`error_severity`, `error_type`, `error_message`, `file_name`, `line_no`, `user_id`, `user_login_id`, `error_datetime`, `user_agent`, `ip_address`) VALUES ('Notice', 'ERROR', 'Undefined index: credit_html', '/home/envdev/public_html/socrato/application/third_party/Smarty/compiled/4b9118d561c950f16d14a93311d1028a6fbc1a9b.file.footer.php.php', 88, '', '', '2018-05-26 01:46:11', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '54.156.76.187')
|
| 0.0010 |
INSERT INTO `debug_log` (`error_severity`, `error_type`, `error_message`, `file_name`, `line_no`, `user_id`, `user_login_id`, `error_datetime`, `user_agent`, `ip_address`) VALUES ('Notice', 'ERROR', 'Trying to get property of non-object', '/home/envdev/public_html/socrato/application/third_party/Smarty/compiled/4b9118d561c950f16d14a93311d1028a6fbc1a9b.file.footer.php.php', 88, '', '', '2018-05-26 01:46:11', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '54.156.76.187')
|
