0.0001 |
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.0311 |
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` ASC, `ep`.`sort_order` ASC LIMIT 10
|
0.0001 |
SELECT FOUND_ROWS() AS count;
|
0.0001 |
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.0677 |
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: my_ip_address', '/home/envdev/public_html/socrato/application/cache/smarty/compiled/6f59bc5aec4ab55f96b4123b748c35bb99f839c1_0.file.header.php.php', 135, '', '', '2019-02-20 09:53:24', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '34.226.208.185')
|
0.0371 |
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/cache/smarty/compiled/6f59bc5aec4ab55f96b4123b748c35bb99f839c1_0.file.header.php.php', 135, '', '', '2019-02-20 09:53:24', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '34.226.208.185')
|
0.0361 |
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/cache/smarty/compiled/50a77186663815bf53528ced8b23648767dc2152_0.file.footer.php.php', 85, '', '', '2019-02-20 09:53:24', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '34.226.208.185')
|
0.0349 |
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/cache/smarty/compiled/50a77186663815bf53528ced8b23648767dc2152_0.file.footer.php.php', 85, '', '', '2019-02-20 09:53:25', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '34.226.208.185')
|