Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.84 ms
(86.23%)
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
  13703
  80999
  151180
  362615
  382408
  383325
  384084
  385271
  389325
  389526
  391134
  391832
  392748
  395580
  398815
  402541
  405820
  406816
  407018
  407058
  407305
  407767
  412289
  413246
  420227
  421404
  422230
  422295
  425035
  426059
  427753
  429205
  431512
  432529
  434282
  438828
  445906
  446299
  447767
  449368
  452648
  454178
  454877
  455140
  458163
  459896
  460702
  461505
  462762
  463397
  464700
  466060
  467810
  469501
  470340
  470930
  473290
  474509
  475539
  476728
  477625
  478012
  479215
  483086
  486925
  491600
  491976
  495715
  498903
  500475
  501512
  504055
  505851
  508247
  509812
  510658
  512731
  513688
  517772
  519649
  522001
  522557
  546977
  551624
  552209
  552480
  553261
  553935
  554897
  557311
  557948
  561661
  563205
  563421
  564145
  568809
  570254
  570918
  571637
  574614
  575077
  575504
  576351
  576731
  578972
  580684
  581541
  584422
  587933
  606783
  624406
  626067
  663365
  665200
  738736
  740747
  743458
  744355
  788275
]
14.94 ms
(7.91%)
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
  362615
  398815
  473290
  463397
  744355
  413246
  420227
  407018
  407305
  454178
  392748
  452648
  552480
  438828
  427753
  429205
  460702
  500475
  568809
  580684
  382408
  383325
  432529
  468318
  458163
  469501
  479215
  522557
  509812
  504055
  402541
  431512
  446299
  454877
  476728
  491600
  571637
  551624
  563421
  570254
  564145
  570918
  626067
  407767
  470340
  478012
  466060
  426059
  461505
  475539
  505851
  483086
  486925
  498903
  517772
  491976
  495715
  522001
  519649
  434282
  474509
  412289
  584422
  587933
  459896
  407058
  422230
  553935
  557948
  421404
  557311
  663365
  665200
  624406
  743458
  738736
  740747
  13703
  391832
  477625
  80999
  405820
  384084
  385271
  151180
  395580
  425035
  445906
  449368
  464700
  546977
  575077
  552209
  554897
  561661
  563205
  575504
  581541
  553261
  574614
  578972
  576351
  576731
  606783
  788275
  389325
  406816
  422295
  389526
  391134
  447767
  467810
  455140
  462762
  470930
  508247
  510658
  513688
  501512
  512731
]
2.98 ms
(1.58%)
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
  13703
  80999
  151180
  362615
  382408
  383325
  384084
  385271
  389325
  389526
  391134
  391832
  392748
  395580
  398815
  402541
  405820
  406816
  407018
  407058
  407305
  407767
  412289
  413246
  420227
  421404
  422230
  422295
  425035
  426059
  427753
  429205
  431512
  432529
  434282
  438828
  445906
  446299
  447767
  449368
  452648
  454178
  454877
  455140
  458163
  459896
  460702
  461505
  462762
  463397
  464700
  466060
  467810
  469501
  470340
  470930
  473290
  474509
  475539
  476728
  477625
  478012
  479215
  483086
  486925
  491600
  491976
  495715
  498903
  500475
  501512
  504055
  505851
  508247
  509812
  510658
  512731
  513688
  517772
  519649
  522001
  522557
  546977
  551624
  552209
  552480
  553261
  553935
  554897
  557311
  557948
  561661
  563205
  563421
  564145
  568809
  570254
  570918
  571637
  574614
  575077
  575504
  576351
  576731
  578972
  580684
  581541
  584422
  587933
  606783
  624406
  626067
  663365
  665200
  738736
  740747
  743458
  744355
  788275
]
2.31 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебется с парнем подруги"
]
2.00 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс парен подружк"
]
1.93 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс парен подружк"
]
1.83 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.