Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
186.31 ms
(88.92%)
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
  428500
  439813
  443743
  450342
  454020
  454216
  454396
  454846
  455993
  457441
  458974
  465353
  466729
  469614
  474785
  474845
  481534
  481557
  482549
  484048
  485696
  486024
  486459
  486781
  486804
  491633
  491783
  492529
  493105
  498405
  506855
  508250
  510815
  511046
  511780
  513130
  514828
  516013
  516651
  517047
  517439
  517689
  517989
  518243
  518573
  518591
  519825
  520217
  523401
  525286
  526675
  527139
  528563
  529406
  530005
  530011
  531524
  532030
  533346
  536639
  537010
  537814
  543286
  543606
  544586
  546874
  547423
  549680
  549702
  557154
  557194
  557246
  559228
  562008
  563021
  563450
  565716
  565717
  565773
  566755
  567468
  568326
  571154
  574414
  574433
  574693
  576267
  577353
  577477
  578180
  580744
  581620
  582235
  586289
  586293
  588015
  592958
  593021
  593029
  593100
  593527
  593792
  598652
  603192
  603424
  605662
  607385
  613576
  614258
  614829
  620230
  621617
  622369
  625219
  625225
  641370
  656672
  678800
  726517
  741779
]
13.43 ms
(6.41%)
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
  518573
  622369
  454846
  485696
  474845
  593100
  469614
  486804
  533346
  741779
  614829
  439813
  457441
  484048
  625219
  726517
  513130
  580744
  620230
  607385
  458974
  614258
  491783
  544586
  519825
  532030
  562008
  593527
  528563
  577477
  598652
  491633
  517047
  527139
  537010
  492529
  574693
  549680
  566755
  578180
  593792
  592958
  621617
  603192
  511046
  571154
  557194
  517439
  516013
  514828
  641370
  563021
  465353
  428500
  454216
  455993
  517689
  537814
  508250
  577353
  568326
  574414
  588015
  454396
  482549
  530005
  586293
  520217
  466729
  593029
  511780
  531524
  454020
  517989
  543606
  656672
  547423
  557154
  613576
  493105
  481534
  565716
  574433
  605662
  443743
  518243
  546874
  678800
  498405
  506855
  543286
  582235
  565773
  581620
  481557
  486781
  593021
  563450
  559228
  576267
  523401
  510815
  536639
  486459
  516651
  518591
  565717
  625225
  557246
  450342
  525286
  530011
  567468
  474785
  603424
  486024
  549702
  529406
  586289
  526675
]
2.84 ms
(1.35%)
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
  428500
  439813
  443743
  450342
  454020
  454216
  454396
  454846
  455993
  457441
  458974
  465353
  466729
  469614
  474785
  474845
  481534
  481557
  482549
  484048
  485696
  486024
  486459
  486781
  486804
  491633
  491783
  492529
  493105
  498405
  506855
  508250
  510815
  511046
  511780
  513130
  514828
  516013
  516651
  517047
  517439
  517689
  517989
  518243
  518573
  518591
  519825
  520217
  523401
  525286
  526675
  527139
  528563
  529406
  530005
  530011
  531524
  532030
  533346
  536639
  537010
  537814
  543286
  543606
  544586
  546874
  547423
  549680
  549702
  557154
  557194
  557246
  559228
  562008
  563021
  563450
  565716
  565717
  565773
  566755
  567468
  568326
  571154
  574414
  574433
  574693
  576267
  577353
  577477
  578180
  580744
  581620
  582235
  586289
  586293
  588015
  592958
  593021
  593029
  593100
  593527
  593792
  598652
  603192
  603424
  605662
  607385
  613576
  614258
  614829
  620230
  621617
  622369
  625219
  625225
  641370
  656672
  678800
  726517
  741779
]
1.87 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм зрелая женщин"
]
1.85 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сперма зрелки"
]
1.63 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.77%)
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.