Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.38 ms
(85.43%)
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
  384760
  395644
  424662
  428855
  445620
  451468
  454257
  454508
  460748
  462332
  466189
  466864
  470962
  479092
  482154
  482361
  484591
  490884
  490888
  490924
  490928
  509267
  521129
  523836
  523838
  531377
  531875
  536299
  537146
  541532
  545220
  546638
  549764
  555180
  558914
  559875
  562963
  563141
  563212
  563214
  564565
  565749
  566393
  572669
  576538
  580598
  591144
  603200
  605049
  605256
  606083
  608430
  610398
  611365
  628600
  629954
  633528
  638557
  646220
  649199
  650793
  663408
  663486
  665288
  665470
  669457
  669736
  671861
  672945
  697758
  714183
  716288
  716294
  718200
  718839
  720612
  725381
  726372
  726478
  726486
  726505
  726514
  726532
  726546
  726547
  726555
  726575
  726827
  726847
  726875
  726923
  732917
  733296
  740310
  741190
  770133
  777359
  784442
  795041
  796072
  796104
  799951
  805122
  805598
  808551
  810069
  810292
  811728
  812965
  814240
  817290
  817825
  817849
  817963
  818391
  821795
  823176
  823466
  824507
  826645
]
15.63 ms
(8.82%)
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
  558914
  563212
  564565
  541532
  555180
  565749
  665288
  718839
  650793
  669736
  697758
  549764
  562963
  563141
  563214
  572669
  638557
  629954
  633528
  606083
  611365
  591144
  805122
  726532
  726827
  795041
  796072
  799951
  810069
  810292
  726505
  726547
  726847
  732917
  733296
  726478
  726575
  726923
  726514
  770133
  726486
  726546
  726555
  726875
  741190
  714183
  451468
  482361
  466864
  470962
  454508
  460748
  462332
  428855
  454257
  479092
  424662
  445620
  509267
  484591
  490884
  521129
  523836
  490888
  490928
  523838
  490924
  466189
  384760
  395644
  817963
  826645
  814240
  817290
  817849
  818391
  821795
  823176
  824507
  817825
  823466
  531875
  537146
  531377
  536299
  482154
  545220
  559875
  566393
  665470
  671861
  646220
  663408
  663486
  672945
  716288
  716294
  649199
  669457
  718200
  720612
  546638
  576538
  580598
  628600
  608430
  610398
  603200
  605049
  605256
  777359
  808551
  784442
  796104
  805598
  811728
  812965
  725381
  740310
  726372
]
3.04 ms
(1.71%)
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
  384760
  395644
  424662
  428855
  445620
  451468
  454257
  454508
  460748
  462332
  466189
  466864
  470962
  479092
  482154
  482361
  484591
  490884
  490888
  490924
  490928
  509267
  521129
  523836
  523838
  531377
  531875
  536299
  537146
  541532
  545220
  546638
  549764
  555180
  558914
  559875
  562963
  563141
  563212
  563214
  564565
  565749
  566393
  572669
  576538
  580598
  591144
  603200
  605049
  605256
  606083
  608430
  610398
  611365
  628600
  629954
  633528
  638557
  646220
  649199
  650793
  663408
  663486
  665288
  665470
  669457
  669736
  671861
  672945
  697758
  714183
  716288
  716294
  718200
  718839
  720612
  725381
  726372
  726478
  726486
  726505
  726514
  726532
  726546
  726547
  726555
  726575
  726827
  726847
  726875
  726923
  732917
  733296
  740310
  741190
  770133
  777359
  784442
  795041
  796072
  796104
  799951
  805122
  805598
  808551
  810069
  810292
  811728
  812965
  814240
  817290
  817825
  817849
  817963
  818391
  821795
  823176
  823466
  824507
  826645
]
1.87 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature condom"
]
1.84 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature condom"
]
1.75 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature condom"
]
1.70 ms
(0.96%)
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.