Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
175.87 ms
(87.24%)
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
  192691
  233133
  383539
  388274
  391600
  393810
  397714
  398593
  399255
  412038
  416905
  418156
  418868
  418882
  419914
  420042
  420901
  421144
  424569
  428963
  430949
  435818
  436478
  441543
  442367
  442988
  447742
  448307
  450699
  451567
  451999
  455798
  455807
  456850
  457043
  457721
  457743
  457787
  457792
  457800
  457801
  458489
  460957
  466451
  469236
  470435
  471699
  474299
  476475
  479928
  480806
  482475
  482940
  484866
  486962
  486978
  487215
  488236
  489431
  489778
  491521
  494126
  495866
  499526
  511030
  512043
  521913
  523934
  528947
  529114
  537721
  541910
  547675
  552505
  556856
  562262
  562281
  562370
  564092
  567467
  578499
  579900
  585342
  599450
  615909
  632020
  648295
  650950
  651917
  671085
  713509
  738630
  770479
  779688
  784887
  787449
  787475
  804374
  806677
  816855
  817484
  817891
  818742
  819097
  819124
  819193
  819469
  820609
  820671
  821134
  821609
  821986
  821997
  822219
  822763
  822974
  823490
  827193
  827683
  828288
]
16.47 ms
(8.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
  419914
  484866
  457043
  547675
  436478
  487215
  450699
  816855
  827193
  818742
  822974
  822763
  827683
  383539
  399255
  482475
  512043
  562262
  562370
  474299
  397714
  421144
  418156
  457800
  632020
  486962
  817484
  819124
  819097
  828288
  651917
  787449
  398593
  416905
  457792
  469236
  455798
  488236
  650950
  428963
  418868
  418882
  420901
  435818
  455807
  523934
  486978
  192691
  823490
  820609
  819469
  821609
  821997
  804374
  787475
  770479
  447742
  448307
  817891
  821134
  458489
  556856
  713509
  738630
  233133
  482940
  499526
  511030
  552505
  585342
  460957
  430949
  457801
  480806
  471699
  579900
  615909
  393810
  821986
  822219
  457721
  457743
  456850
  567467
  541910
  779688
  412038
  388274
  451999
  489431
  494126
  562281
  441543
  391600
  420042
  529114
  820671
  819193
  489778
  451567
  470435
  537721
  466451
  564092
  784887
  806677
  442988
  491521
  521913
  599450
  442367
  424569
  495866
  528947
  578499
  671085
  648295
  457787
  476475
  479928
]
2.69 ms
(1.34%)
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
  192691
  233133
  383539
  388274
  391600
  393810
  397714
  398593
  399255
  412038
  416905
  418156
  418868
  418882
  419914
  420042
  420901
  421144
  424569
  428963
  430949
  435818
  436478
  441543
  442367
  442988
  447742
  448307
  450699
  451567
  451999
  455798
  455807
  456850
  457043
  457721
  457743
  457787
  457792
  457800
  457801
  458489
  460957
  466451
  469236
  470435
  471699
  474299
  476475
  479928
  480806
  482475
  482940
  484866
  486962
  486978
  487215
  488236
  489431
  489778
  491521
  494126
  495866
  499526
  511030
  512043
  521913
  523934
  528947
  529114
  537721
  541910
  547675
  552505
  556856
  562262
  562281
  562370
  564092
  567467
  578499
  579900
  585342
  599450
  615909
  632020
  648295
  650950
  651917
  671085
  713509
  738630
  770479
  779688
  784887
  787449
  787475
  804374
  806677
  816855
  817484
  817891
  818742
  819097
  819124
  819193
  819469
  820609
  820671
  821134
  821609
  821986
  821997
  822219
  822763
  822974
  823490
  827193
  827683
  828288
]
1.92 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beach teens"
]
1.66 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пляж природ teens"
]
1.51 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пляж природ teens"
]
1.47 ms
(0.73%)
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.