Database Queries

Всего 22 записи.
TimeDurationTypeDuplicatedQuery
   
23:00:40.4054.1 msSELECT1
SELECT * FROM `blog_posts` WHERE (`status`=1) AND (`id`='9')

23:00:40.4100.4 msSHOW1
SHOW FULL COLUMNS FROM `blog_posts`
23:00:40.4100.3 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'blog_posts' AND kcu.table_name = 'blog_posts'

23:00:40.4111.1 msSELECT1
SELECT * FROM `blog_categories` WHERE `id`=1

23:00:40.4120.2 msSHOW1
SHOW FULL COLUMNS FROM `blog_categories`
23:00:40.4120.2 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'blog_categories' AND kcu.table_name = 'blog_categories'

23:00:40.4131.5 msSELECT1
SELECT * FROM `blog_tag_assignments` WHERE `post_id`=9

23:00:40.4140.2 msSELECT1
SELECT * FROM `blog_tags` WHERE 0=1

23:00:40.4381.3 msSELECT1
SELECT * FROM `blog_comments` WHERE `post_id`=9 ORDER BY `parent_id`, `id`

23:00:40.4411.5 msSELECT1
SELECT * FROM `contact`

23:00:40.4430.3 msSHOW1
SHOW FULL COLUMNS FROM `contact`
23:00:40.4430.3 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'contact' AND kcu.table_name = 'contact'

23:00:40.4431.0 msSELECT1
SELECT * FROM `icon`

23:00:40.4440.2 msSHOW1
SHOW FULL COLUMNS FROM `icon`
23:00:40.4450.3 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'icon' AND kcu.table_name = 'icon'

23:00:40.4451.3 msSELECT1
SELECT `menu_id` FROM `menu` WHERE `menu_name`='Главное меню' LIMIT 10

23:00:40.4470.9 msSELECT1
SELECT * FROM `address`

23:00:40.4480.4 msSHOW1
SHOW FULL COLUMNS FROM `address`
23:00:40.4480.2 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'address' AND kcu.table_name = 'address'

23:00:40.4490.6 msSELECT1
SELECT * FROM `menu` WHERE `menu_id`='1'

23:00:40.4500.2 msSHOW1
SHOW FULL COLUMNS FROM `menu`
23:00:40.4500.2 msSELECT1
SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'menu' AND kcu.table_name = 'menu'