Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.07 ms
(84.21%)
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
  382585
  385832
  388544
  397464
  398783
  399952
  403393
  405707
  411494
  420677
  420775
  425322
  426021
  443769
  444199
  445948
  449407
  453524
  453595
  455409
  455787
  456023
  458357
  461230
  461250
  461489
  461999
  462170
  462528
  463737
  466016
  470101
  470597
  472106
  473228
  473761
  474229
  475012
  477198
  477449
  478711
  480094
  482028
  483242
  483614
  485640
  488726
  490786
  491188
  491367
  491744
  492153
  497091
  497871
  498455
  500403
  500704
  503753
  506217
  508546
  509672
  509764
  510048
  513408
  514408
  521872
  521981
  522796
  523974
  525883
  533138
  552079
  560002
  560469
  561245
  562165
  565439
  567830
  573008
  584424
  589720
  595888
  596347
  598145
  598558
  598591
  598994
  603948
  617096
  656044
  657077
  657603
  658616
  673170
  676527
  709295
  720649
  722855
  723017
  723599
  741808
  741989
  742938
  748437
  754650
  761471
  761797
  762076
  764107
  772588
  777827
  778761
  779195
  779300
  781087
  783162
  787902
  794945
  796701
  800231
]
14.11 ms
(9.21%)
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
  482028
  778761
  761797
  772588
  509672
  794945
  455787
  742938
  561245
  787902
  513408
  483242
  779195
  560002
  426021
  754650
  584424
  473761
  411494
  477449
  598994
  506217
  723599
  657603
  420775
  474229
  461250
  461489
  462170
  445948
  514408
  741989
  617096
  598145
  461999
  560469
  598558
  676527
  473228
  462528
  388544
  777827
  478711
  444199
  603948
  449407
  509764
  565439
  523974
  453524
  596347
  522796
  463737
  490786
  552079
  455409
  470597
  525883
  521981
  500704
  658616
  723017
  657077
  741808
  475012
  397464
  398783
  480094
  382585
  500403
  491367
  488726
  709295
  533138
  783162
  762076
  420677
  453595
  779300
  748437
  562165
  521872
  656044
  796701
  761471
  764107
  781087
  399952
  466016
  483614
  498455
  497871
  503753
  458357
  403393
  567830
  573008
  385832
  461230
  491744
  405707
  800231
  722855
  508546
  497091
  456023
  425322
  595888
  472106
  477198
  510048
  485640
  491188
  492153
  443769
  589720
  470101
  720649
  673170
  598591
]
2.49 ms
(1.63%)
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
  382585
  385832
  388544
  397464
  398783
  399952
  403393
  405707
  411494
  420677
  420775
  425322
  426021
  443769
  444199
  445948
  449407
  453524
  453595
  455409
  455787
  456023
  458357
  461230
  461250
  461489
  461999
  462170
  462528
  463737
  466016
  470101
  470597
  472106
  473228
  473761
  474229
  475012
  477198
  477449
  478711
  480094
  482028
  483242
  483614
  485640
  488726
  490786
  491188
  491367
  491744
  492153
  497091
  497871
  498455
  500403
  500704
  503753
  506217
  508546
  509672
  509764
  510048
  513408
  514408
  521872
  521981
  522796
  523974
  525883
  533138
  552079
  560002
  560469
  561245
  562165
  565439
  567830
  573008
  584424
  589720
  595888
  596347
  598145
  598558
  598591
  598994
  603948
  617096
  656044
  657077
  657603
  658616
  673170
  676527
  709295
  720649
  722855
  723017
  723599
  741808
  741989
  742938
  748437
  754650
  761471
  761797
  762076
  764107
  772588
  777827
  778761
  779195
  779300
  781087
  783162
  787902
  794945
  796701
  800231
]
2.15 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет красотки русские"
]
1.96 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс красивая русск"
]
1.95 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.01%)
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.