0.0015 |
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('8ac1d93b60cf5a0bbcc72e881198e16d', '3.238.94.194', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1653122496, '')
|
0.0154 |
SELECT `publication_id`, `abstract_content`, `publish_year`, `publish_month`, `publish_date`, `home_page_summary`, `home_page_title`, `cover_image`, `authors`, (CASE WHEN authors IS not NULL AND authors !=' ' then if(locate(', ', authors) > 0, CONCAT(SUBSTRING_INDEX( GROUP_CONCAT(auth_name SEPARATOR '; '), ';', length( GROUP_CONCAT(auth_name SEPARATOR '; '))-length(replace( GROUP_CONCAT(auth_name SEPARATOR '; '), ';', ''))), ' AND ', SUBSTRING_INDEX( GROUP_CONCAT(auth_name SEPARATOR '; '), '; ', -1)), GROUP_CONCAT(auth_name SEPARATOR ';') ) ELSE ' ' end) as authorsname1 FROM (`publication_master` p, `author_master`) WHERE (find_in_set(auth_id,authors) OR authors IS NULL or authors = '') AND `p`.`IS_Status` = 1 AND `lang_id` = 'mr' GROUP BY `publication_id` ORDER BY `publish_year` Desc, `publication_id` Desc
|
0.0010 |
SELECT `publication_id`, `home_page_title`, `lang_id` FROM (`publication_master` p) WHERE `p`.`IS_Status` = 1 AND `lang_id` NOT IN ('en') GROUP BY `publication_id` ORDER BY `publish_year` Desc LIMIT 15
|
0.0005 |
SELECT `t1`.`cat_name` AS lev1, `t1`.`cat_id` AS lev1_catid, `t2`.`cat_name` as lev2, `t2`.`cat_id` AS lev2_catid, `t3`.`cat_name` as lev3, `t3`.`cat_id` AS lev3_catid, `t4`.`cat_name` as lev4, `t4`.`cat_id` AS lev4_catid FROM (`categories_master` as t1) LEFT JOIN `categories_master` as t2 ON `t2`.`parent_cat_id` = `t1`.`cat_id` LEFT JOIN `categories_master` t3 ON `t3`.`parent_cat_id` = `t2`.`cat_id` LEFT JOIN `categories_master` t4 ON `t4`.`parent_cat_id` = `t3`.`cat_id` WHERE `t1`.`parent_cat_id` = 0 AND `t1`.`IS_STATUS` = 1
|
0.0004 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '292'
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '291'
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '122'
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '26'
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = ''
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '174'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = ''
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '270'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = ''
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = ''
|
0.0000 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = ''
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '196'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '174'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '196'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = ''
|
0.0000 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '174'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '196'
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '202'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '174'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '196'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = ''
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = ''
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '174'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = ''
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '26'
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '161'
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '169'
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '170'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '169'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '170'
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '171'
|
0.0002 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '192'
|
0.0001 |
SELECT `auth_name` FROM (`author_master`) WHERE `auth_id` = '196'
|
0.0000 |
INSERT INTO `ip_log` (`ipaddress`) VALUES ('3.238.94.194')
|
0.0012 |
UPDATE `ci_sessions` SET `last_activity` = 1653122496, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:6:\"server\";s:12:\"3.238.94.194\";}' WHERE `session_id` = '8ac1d93b60cf5a0bbcc72e881198e16d'
|
0.0001 |
SELECT count(*) as totalhits FROM (`ip_log`)
|