Query Metrics

7 Database Queries
7 Different statements
170.60 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
143.00 ms
(83.82%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  88664
  182036
  182895
  209216
  357457
  394648
  398123
  402648
  410242
  413404
  414048
  414064
  415857
  417430
  428773
  429044
  429566
  434314
  434318
  434330
  434345
  437708
  440639
  444540
  448079
  449014
  449017
  449022
  449023
  452807
  452898
  454688
  456699
  457650
  457812
  457815
  458772
  467058
  469092
  472257
  475417
  475419
  476668
  478519
  478523
  479723
  479727
  482293
  486243
  486244
  486768
  486783
  495211
  496842
  499922
  499927
  502772
  509978
  515253
  515259
  521559
  522148
  522156
  522173
  522182
  522579
  526165
  538669
  549538
  554907
  566545
  569720
  571039
  623267
  623284
  633463
  634109
  634180
  660419
  662856
  681804
  697839
  720593
  728268
  730075
  730102
  731794
  734844
  734868
  738499
  738501
  741157
  744227
  745111
  752550
  755936
  756752
  760471
  762303
  766294
  770258
  773308
  776059
  777921
  785267
  786023
  796266
  796681
  796687
  804159
  804939
  806393
  806543
  806687
  806861
  807562
  807581
  808644
  808994
  819361
]
17.22 ms
(10.09%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  755936
  730102
  738499
  720593
  796266
  457812
  209216
  479723
  479727
  458772
  434314
  449022
  623284
  182895
  394648
  398123
  444540
  486244
  452807
  486768
  807562
  478519
  486783
  402648
  429566
  428773
  429044
  502772
  734844
  731794
  804939
  773308
  623267
  796687
  770258
  807581
  182036
  566545
  569720
  806543
  738501
  806687
  744227
  88664
  448079
  449014
  522156
  515253
  633463
  634180
  808644
  730075
  808994
  752550
  776059
  554907
  414064
  741157
  806861
  413404
  522148
  662856
  785267
  414048
  449023
  482293
  415857
  357457
  819361
  456699
  449017
  457815
  486243
  760471
  766294
  478523
  410242
  495211
  515259
  734868
  475417
  521559
  475419
  434330
  440639
  571039
  660419
  467058
  417430
  469092
  526165
  476668
  434345
  454688
  457650
  452898
  522579
  756752
  434318
  509978
  538669
  472257
  762303
  697839
  728268
  499927
  549538
  634109
  806393
  786023
  745111
  777921
  796681
  804159
  437708
  496842
  522173
  522182
  499922
  681804
]
3.46 ms
(2.03%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  88664
  182036
  182895
  209216
  357457
  394648
  398123
  402648
  410242
  413404
  414048
  414064
  415857
  417430
  428773
  429044
  429566
  434314
  434318
  434330
  434345
  437708
  440639
  444540
  448079
  449014
  449017
  449022
  449023
  452807
  452898
  454688
  456699
  457650
  457812
  457815
  458772
  467058
  469092
  472257
  475417
  475419
  476668
  478519
  478523
  479723
  479727
  482293
  486243
  486244
  486768
  486783
  495211
  496842
  499922
  499927
  502772
  509978
  515253
  515259
  521559
  522148
  522156
  522173
  522182
  522579
  526165
  538669
  549538
  554907
  566545
  569720
  571039
  623267
  623284
  633463
  634109
  634180
  660419
  662856
  681804
  697839
  720593
  728268
  730075
  730102
  731794
  734844
  734868
  738499
  738501
  741157
  744227
  745111
  752550
  755936
  756752
  760471
  762303
  766294
  770258
  773308
  776059
  777921
  785267
  786023
  796266
  796681
  796687
  804159
  804939
  806393
  806543
  806687
  806861
  807562
  807581
  808644
  808994
  819361
]
1.87 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "оттрахана секс машино…"
]
1.85 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс сексмашин"
]
1.70 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс сексмашин"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.