Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
111.90 ms
(82.17%)
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
  191179
  389482
  395306
  396740
  397508
  397766
  400465
  402792
  405897
  408644
  412332
  416300
  417782
  417940
  418594
  423499
  423708
  426496
  428568
  434523
  434817
  438417
  443242
  444296
  452876
  454981
  455360
  456666
  467569
  469615
  475943
  488897
  507284
  509170
  514837
  515143
  522112
  529152
  530011
  531106
  531115
  531124
  531250
  531524
  534019
  534032
  534386
  534999
  537239
  537654
  540915
  541103
  544835
  553808
  556876
  556880
  556888
  566784
  570740
  580160
  580174
  584362
  588177
  600200
  600218
  610313
  622792
  625026
  625189
  628409
  632594
  637021
  637023
  638744
  639810
  642066
  651168
  663217
  678127
  684513
  698801
  702629
  702971
  705200
  709523
  711597
  716596
  717318
  719767
  720438
  722677
  724023
  725624
  727944
  727959
  735446
  736850
  738471
  739178
  740492
  741808
  741935
  744896
  755125
  766649
  770405
  782302
  783271
  786791
  788887
  796147
  796744
  797006
  806688
  808155
  808997
  809001
  823929
]
15.21 ms
(11.17%)
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
  705200
  702971
  534386
  651168
  544835
  438417
  389482
  396740
  400465
  405897
  434817
  823929
  531250
  541103
  553808
  556888
  540915
  584362
  663217
  720438
  556880
  566784
  638744
  808997
  738471
  740492
  766649
  788887
  809001
  397766
  412332
  416300
  452876
  426496
  444296
  454981
  515143
  529152
  698801
  711597
  610313
  622792
  782901
  727944
  741808
  744896
  755125
  625026
  702629
  684513
  763214
  531115
  531524
  507284
  632594
  600200
  637023
  628409
  717318
  639810
  509170
  537239
  709523
  719767
  588177
  782302
  796147
  796744
  724023
  797006
  395306
  402792
  428568
  434523
  423499
  423708
  417782
  467569
  456666
  534019
  534032
  514837
  534999
  556876
  580160
  580174
  808155
  806688
  770405
  727959
  417940
  455360
  469615
  475943
  488897
  522112
  783271
  600218
  537654
  531124
  530011
  531106
  678127
  637021
  642066
  716596
  722677
  570740
  625189
  786791
  725624
  741935
  736850
  739178
  735446
  191179
  397508
  408644
  418594
  443242
]
2.32 ms
(1.70%)
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
  191179
  389482
  395306
  396740
  397508
  397766
  400465
  402792
  405897
  408644
  412332
  416300
  417782
  417940
  418594
  423499
  423708
  426496
  428568
  434523
  434817
  438417
  443242
  444296
  452876
  454981
  455360
  456666
  467569
  469615
  475943
  488897
  507284
  509170
  514837
  515143
  522112
  529152
  530011
  531106
  531115
  531124
  531250
  531524
  534019
  534032
  534386
  534999
  537239
  537654
  540915
  541103
  544835
  553808
  556876
  556880
  556888
  566784
  570740
  580160
  580174
  584362
  588177
  600200
  600218
  610313
  622792
  625026
  625189
  628409
  632594
  637021
  637023
  638744
  639810
  642066
  651168
  663217
  678127
  684513
  698801
  702629
  702971
  705200
  709523
  711597
  716596
  717318
  719767
  720438
  722677
  724023
  725624
  727944
  727959
  735446
  736850
  738471
  739178
  740492
  741808
  741935
  744896
  755125
  766649
  770405
  782302
  783271
  786791
  788887
  796147
  796744
  797006
  806688
  808155
  808997
  809001
  823929
]
2.00 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "extreme cum"
]
1.74 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "хардкор cum"
]
1.51 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "хардкор cum"
]

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.