Database Queries

Check application configuration section [log] for traceLevel

53 duplicated queries found.

Razem 122 rekordy.
TimeDurationTypeDuplicatedQuery
   
05:07:31.4080,2 msSELECT1
SELECT * FROM `cms_website` WHERE (`cms_website`.`is_deleted`=FALSE) AND (`is_active`=TRUE)

05:07:31.4080,1 msSELECT1
SELECT `base_path` FROM `cms_theme` WHERE `is_default`=1

05:07:31.4120,1 msSELECT1
SELECT `value`, `name` FROM `admin_config`

05:07:31.4140,1 msSELECT1
SELECT GET_LOCK('14c2c3805cf9fe67e7c8cb8bd42d65a0479e6079', 3)

05:07:31.4140,4 msSHOW1
SHOW FULL COLUMNS FROM `admin_queue`
05:07:31.4150,2 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'admin_queue' AND `kcu`.`TABLE_NAME` = 'admin_queue'

05:07:31.4150,1 msUPDATE1
UPDATE `admin_queue` SET `reserved_at`=NULL WHERE `reserved_at` is not null and `reserved_at` < 1756264051 - `ttr` and `done_at` is null

05:07:31.4150,1 msSELECT1
SELECT * FROM `admin_queue` WHERE ((`channel`='default') AND (`reserved_at` IS NULL)) AND (`pushed_at` <= 1756264051 - `delay`) ORDER BY `priority`, `id` LIMIT 1

05:07:31.4160,1 msSELECT1
SELECT RELEASE_LOCK('14c2c3805cf9fe67e7c8cb8bd42d65a0479e6079')

05:07:31.4160,1 msSELECT1
SELECT * FROM `admin_config` WHERE `name`='queue_timestamp'

05:07:31.4180,2 msSHOW1
SHOW FULL COLUMNS FROM `admin_config`
05:07:31.4180,1 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'admin_config' AND `kcu`.`TABLE_NAME` = 'admin_config'

05:07:31.4220,1 msUPDATE1
UPDATE `admin_config` SET `value`='1756264051' WHERE `id`=5

05:07:31.4250,1 msSELECT1
SELECT `short_code`, `id` FROM `admin_lang`

05:07:31.4250,5 msSELECT1
SELECT `item`.`id`, `item`.`nav_id`, `item`.`title`, `item`.`description`, `item`.`keywords`, `item`.`image_id`, `item`.`is_url_strict_parsing_disabled`, `item`.`alias`, `item`.`title_tag`, `item`.`timestamp_create`, `item`.`timestamp_update`, `item`.`create_user_id`, `item`.`update_user_id`, `nav`.`is_home`, `nav`.`parent_nav_id`, `nav`.`sort_index`, `nav`.`is_hidden`, `item`.`nav_item_type`, `item`.`nav_item_type_id`, `nav_container`.`alias` AS `container` FROM `cms_nav_item` `item` LEFT JOIN `cms_nav` `nav` ON nav.id=item.nav_id LEFT JOIN `cms_nav_container` `nav_container` ON nav_container.id=nav.nav_container_id WHERE (`nav`.`is_deleted`=FALSE) AND (`nav_container`.`website_id`=1) AND (`item`.`lang_id`=1) AND (`nav`.`is_offline`=FALSE) AND (`nav`.`is_draft`=FALSE) ORDER BY `container`, `parent_nav_id`, `nav`.`sort_index`

05:07:31.4250,1 msSELECT1
SELECT `id`, `type`, `value`, `target` FROM `cms_nav_item_redirect`

05:07:31.4280,1 msSELECT1
SELECT * FROM `admin_lang` WHERE `is_deleted`=FALSE ORDER BY `is_default` DESC

05:07:31.4280,1 msSELECT1
SELECT `is_cacheable` FROM `cms_nav_item` WHERE (`nav_id`=32) AND (`lang_id`=1)

05:07:31.4290,1 msSELECT1
SELECT * FROM `cms_nav_item` WHERE `id`=34

05:07:31.4290,3 msSHOW1
SHOW FULL COLUMNS FROM `cms_nav_item`
05:07:31.4290,2 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'cms_nav_item' AND `kcu`.`TABLE_NAME` = 'cms_nav_item'

05:07:31.4310,1 msSELECT2
SELECT * FROM `cms_nav` WHERE `id`=32

05:07:31.4310,3 msSHOW1
SHOW FULL COLUMNS FROM `cms_nav`
05:07:31.4310,2 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'cms_nav' AND `kcu`.`TABLE_NAME` = 'cms_nav'

05:07:31.4320,1 msSELECT2
SELECT * FROM `cms_nav_property` WHERE `nav_id`=32

05:07:31.4330,3 msSHOW1
SHOW FULL COLUMNS FROM `cms_nav_item_page`
05:07:31.4330,2 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'cms_nav_item_page' AND `kcu`.`TABLE_NAME` = 'cms_nav_item_page'

05:07:31.4330,1 msSELECT1
SELECT * FROM `cms_nav_item_page` WHERE `id`=25

05:07:31.4340,1 msSELECT1
SELECT * FROM `cms_layout` WHERE `id`=3

05:07:31.4350,2 msSHOW1
SHOW FULL COLUMNS FROM `cms_layout`
05:07:31.4350,1 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'cms_layout' AND `kcu`.`TABLE_NAME` = 'cms_layout'

05:07:31.4360,2 msSELECT1
SELECT `t1`.`id`, `t1`.`block_id`, `t1`.`json_config_values`, `t1`.`json_config_cfg_values`, `t1`.`variation`, `t2`.`class` FROM `cms_nav_item_page_block_item` `t1` INNER JOIN `cms_block` `t2` ON t2.id=t1.block_id WHERE (`nav_item_page_id`=25) AND (`placeholder_var`='kvinner') AND (`prev_id`=0) AND (`is_hidden`=0) ORDER BY `sort_index`

05:07:31.4390,2 msSELECT10
SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC

05:07:31.4430,3 msSHOW1
SHOW FULL COLUMNS FROM `konkurs_edycja`
05:07:31.4430,1 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'konkurs_edycja' AND `kcu`.`TABLE_NAME` = 'konkurs_edycja'

05:07:31.4460,3 msSHOW1
SHOW FULL COLUMNS FROM `konkurs_jury`
05:07:31.4460,2 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'konkurs_jury' AND `kcu`.`TABLE_NAME` = 'konkurs_jury'

05:07:31.4460,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.4486,8 msSELECT1
SELECT `id`, `file_id`, `filter_id`, `resolution_width`, `resolution_height` FROM `admin_storage_image`

05:07:31.4606,1 msSELECT1
SELECT `id`, `is_hidden`, `is_deleted`, `folder_id`, `name_original`, `name_new`, `name_new_compound`, `mime_type`, `extension`, `hash_name`, `hash_file`, `upload_timestamp`, `file_size`, `upload_user_id`, `caption` FROM `admin_storage_file`

05:07:31.4680,3 msSELECT1
SELECT `t1`.`id`, `t1`.`block_id`, `t1`.`json_config_values`, `t1`.`json_config_cfg_values`, `t1`.`variation`, `t2`.`class` FROM `cms_nav_item_page_block_item` `t1` INNER JOIN `cms_block` `t2` ON t2.id=t1.block_id WHERE (`nav_item_page_id`=25) AND (`placeholder_var`='content') AND (`prev_id`=0) AND (`is_hidden`=0) ORDER BY `sort_index`

05:07:31.4690,2 msSELECT10
SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC

05:07:31.4700,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.4712,8 msSELECT2
SELECT * FROM `konkurs_praca` WHERE (`id_edycja`=26) AND (`miejsce`=1) ORDER BY `miejsce`

05:07:31.4740,4 msSHOW1
SHOW FULL COLUMNS FROM `konkurs_praca`
05:07:31.4750,2 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'konkurs_praca' AND `kcu`.`TABLE_NAME` = 'konkurs_praca'

05:07:31.4762,7 msSELECT2
SELECT * FROM `konkurs_praca` WHERE (`id_edycja`=26) AND (`miejsce`=1) ORDER BY `miejsce`

05:07:31.4800,2 msSELECT10
SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC

05:07:31.4820,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.4821,0 msSELECT1
SELECT * FROM `konkurs_praca` WHERE (`id_edycja`=26) AND (`miejsce` > 1) ORDER BY `nazwisko`

05:07:31.4891,0 msSELECT1
SELECT * FROM `konkurs_praca` WHERE (`id_edycja`=26) AND (miejsce_partner is not null and miejsce_partner > 0) ORDER BY `miejsce_partner`, `nazwisko`

05:07:31.4910,1 msSELECT1
SELECT `id`, `identifier`, `name` FROM `admin_storage_filter` ORDER BY `name`

05:07:31.5100,3 msSELECT10
SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC

05:07:31.5130,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.5140,2 msSELECT1
SELECT * FROM `konkurs_praca_motion` WHERE (`id_edycja`=26) AND (`miejsce` > 1) ORDER BY `nazwisko`

05:07:31.5140,1 msSELECT1
SELECT * FROM `konkurs_praca_motion` WHERE (`id_edycja`=26) AND (miejsce_partner is not null and miejsce_partner > 0) ORDER BY `miejsce_partner`, `nazwisko`

05:07:31.5150,3 msSHOW1
SHOW FULL COLUMNS FROM `konkurs_praca_motion`
05:07:31.5150,2 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'konkurs_praca_motion' AND `kcu`.`TABLE_NAME` = 'konkurs_praca_motion'

05:07:31.5160,1 msSELECT3
SELECT * FROM `konkurs_praca_motion` WHERE (`id_edycja`=26) AND (`miejsce`=1) ORDER BY `miejsce`

05:07:31.5170,2 msSELECT3
SELECT * FROM `konkurs_praca_motion` WHERE (`id_edycja`=26) AND (`miejsce`=1) ORDER BY `miejsce`

05:07:31.5170,2 msSELECT3
SELECT * FROM `konkurs_praca_motion` WHERE (`id_edycja`=26) AND (`miejsce`=1) ORDER BY `miejsce`

05:07:31.5250,2 msSELECT10
SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC

05:07:31.5260,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.5390,2 msSELECT10
SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC

05:07:31.5410,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.5420,2 msSELECT10
SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC

05:07:31.5430,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.5461,0 msSELECT1
SELECT COUNT(*) FROM `konkurs_praca` WHERE ((`id_edycja`=26) AND (`dubel`=0)) AND (aktywna = 1 or (aktywna = 0 and zaakceptowano is null))

05:07:31.5513,0 msSELECT1
SELECT * FROM `konkurs_praca` WHERE ((`id_edycja`=26) AND (`dubel`=0)) AND (aktywna = 1 or (aktywna = 0 and zaakceptowano is null)) ORDER BY rand() LIMIT 12

05:07:31.6100,3 msSELECT10
SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC

05:07:31.6140,2 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6150,1 msSELECT1
SELECT COUNT(*) FROM `konkurs_praca_motion` WHERE ((`id_edycja`=26) AND (`dubel`=0)) AND (aktywna = 1 or (aktywna = 0 and zaakceptowano is null))

05:07:31.6160,5 msSELECT1
SELECT * FROM `konkurs_praca_motion` WHERE ((`id_edycja`=26) AND (`dubel`=0)) AND (aktywna = 1 or (aktywna = 0 and zaakceptowano is null)) ORDER BY rand() LIMIT 12

05:07:31.6290,2 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6310,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6360,2 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6370,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6410,2 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6420,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6460,1 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6470,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6510,1 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6520,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6560,1 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6570,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6610,1 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6620,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6660,1 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6670,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6710,1 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6720,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6760,1 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6770,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6810,1 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6820,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6850,1 msSELECT12
SELECT * FROM `konkurs_edycja` WHERE `id`=26

05:07:31.6870,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6880,2 msSELECT10
SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC

05:07:31.6890,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6890,1 msSELECT1
SELECT * FROM `konkurs_edycja_jury` WHERE `id_edycja`=26

05:07:31.6890,1 msSELECT1
SELECT * FROM `konkurs_jury` WHERE 0=1 ORDER BY SUBSTR(`imie_nazwisko`, INSTR(`imie_nazwisko`, " "))

05:07:31.6900,2 msSELECT10
SELECT * FROM `konkurs_edycja` WHERE `aktywna`=1 ORDER BY `numer` DESC

05:07:31.6910,1 msSELECT22
SELECT `konkurs_jury`.* FROM `konkurs_jury` LEFT JOIN `konkurs_edycja_jury` ON `konkurs_jury`.id=konkurs_edycja_jury.id_jury WHERE `konkurs_edycja_jury`.`id_edycja`=26

05:07:31.6920,1 msSELECT1
SELECT * FROM `news_cat` ORDER BY `title`

05:07:31.6920,3 msSHOW1
SHOW FULL COLUMNS FROM `news_cat`
05:07:31.6930,2 msSELECT1
SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'news_cat' AND `kcu`.`TABLE_NAME` = 'news_cat'

05:07:31.6950,2 msSELECT1
SELECT * FROM `news_article` WHERE (`news_article`.`is_deleted`=FALSE) AND ((`is_online`=TRUE) AND (`is_archived`=FALSE)) AND (`cat_id`=0) ORDER BY `timestamp_create` DESC LIMIT 10

05:07:31.6960,2 msSELECT1
SELECT `t1`.`id`, `t1`.`block_id`, `t1`.`json_config_values`, `t1`.`json_config_cfg_values`, `t1`.`variation`, `t2`.`class` FROM `cms_nav_item_page_block_item` `t1` INNER JOIN `cms_block` `t2` ON t2.id=t1.block_id WHERE (`nav_item_page_id`=25) AND (`placeholder_var`='footer') AND (`prev_id`=0) AND (`is_hidden`=0) ORDER BY `sort_index`

05:07:31.6970,1 msSELECT1
SELECT * FROM `cms_nav` WHERE `id`=16

05:07:31.6980,1 msSELECT1
SELECT * FROM `cms_nav_property` WHERE `nav_id`=16

05:07:31.6980,1 msSELECT1
SELECT * FROM `cms_nav` WHERE `id`=13

05:07:31.6980,1 msSELECT1
SELECT * FROM `cms_nav_property` WHERE `nav_id`=13

05:07:31.6980,1 msSELECT1
SELECT * FROM `cms_nav` WHERE `id`=29

05:07:31.6990,1 msSELECT1
SELECT * FROM `cms_nav_property` WHERE `nav_id`=29

05:07:31.6990,1 msSELECT1
SELECT * FROM `cms_nav` WHERE `id`=15

05:07:31.6990,1 msSELECT1
SELECT * FROM `cms_nav_property` WHERE `nav_id`=15

05:07:31.6990,1 msSELECT1
SELECT * FROM `cms_nav` WHERE `id`=37

05:07:31.6990,1 msSELECT1
SELECT * FROM `cms_nav_property` WHERE `nav_id`=37

05:07:31.7000,1 msSELECT1
SELECT * FROM `cms_nav` WHERE `id`=36

05:07:31.7010,1 msSELECT1
SELECT * FROM `cms_nav_property` WHERE `nav_id`=36

05:07:31.7110,1 msSELECT2
SELECT * FROM `cms_nav` WHERE `id`=32

05:07:31.7110,1 msSELECT2
SELECT * FROM `cms_nav_property` WHERE `nav_id`=32