Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.72 ms
(84.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
  205520
  360015
  395547
  395609
  395812
  398559
  399209
  400965
  401305
  401932
  401936
  415112
  415223
  418418
  420331
  420439
  422511
  422565
  422652
  422657
  422670
  422709
  422863
  422901
  422936
  422985
  422996
  423006
  423007
  428631
  431333
  433185
  437084
  439658
  439844
  445897
  445933
  446875
  448325
  451554
  455841
  459360
  461723
  463811
  466161
  466987
  473955
  476962
  484730
  486354
  489661
  491232
  491644
  494692
  496818
  509940
  510505
  511809
  518472
  520729
  524089
  530494
  530670
  531090
  532831
  534280
  536218
  543013
  548548
  548574
  551081
  561982
  562511
  565255
  565259
  579358
  595853
  596501
  596616
  597266
  604417
  604507
  613287
  615718
  619409
  620851
  622391
  622397
  628090
  628365
  628368
  628407
  628420
  632046
  633782
  637078
  637134
  646229
  647850
  647877
  647969
  659392
  659409
  671676
  672805
  699610
  714436
  714480
  714497
  722689
  723927
  733884
  733886
  741109
  760958
  777551
  788198
  791181
  800421
  820385
]
19.11 ms
(10.08%)
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
  659392
  672805
  723927
  360015
  422996
  422652
  551081
  647877
  699610
  659409
  646229
  632046
  415112
  510505
  620851
  791181
  820385
  800421
  777551
  788198
  613287
  415223
  466987
  484730
  548548
  548574
  395812
  399209
  420331
  466161
  431333
  494692
  532831
  486354
  491644
  423006
  437084
  445933
  455841
  451554
  562511
  543013
  561982
  722689
  714480
  622391
  619409
  596501
  628407
  741109
  604417
  622397
  401932
  439658
  476962
  401936
  418418
  473955
  395609
  398559
  448325
  422985
  463811
  491232
  520729
  205520
  395547
  400965
  401305
  422709
  422901
  422936
  428631
  422670
  422511
  422565
  422657
  445897
  459360
  511809
  524089
  534280
  530494
  531090
  536218
  579358
  565255
  647969
  647850
  671676
  714497
  604507
  637134
  595853
  597266
  628365
  628090
  628368
  637078
  628420
  733884
  733886
  760958
  633782
  714436
  439844
  446875
  420439
  422863
  489661
  496818
  518472
  509940
  433185
  530670
  565259
  615718
  596616
  461723
  423007
]
3.42 ms
(1.80%)
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
  205520
  360015
  395547
  395609
  395812
  398559
  399209
  400965
  401305
  401932
  401936
  415112
  415223
  418418
  420331
  420439
  422511
  422565
  422652
  422657
  422670
  422709
  422863
  422901
  422936
  422985
  422996
  423006
  423007
  428631
  431333
  433185
  437084
  439658
  439844
  445897
  445933
  446875
  448325
  451554
  455841
  459360
  461723
  463811
  466161
  466987
  473955
  476962
  484730
  486354
  489661
  491232
  491644
  494692
  496818
  509940
  510505
  511809
  518472
  520729
  524089
  530494
  530670
  531090
  532831
  534280
  536218
  543013
  548548
  548574
  551081
  561982
  562511
  565255
  565259
  579358
  595853
  596501
  596616
  597266
  604417
  604507
  613287
  615718
  619409
  620851
  622391
  622397
  628090
  628365
  628368
  628407
  628420
  632046
  633782
  637078
  637134
  646229
  647850
  647877
  647969
  659392
  659409
  671676
  672805
  699610
  714436
  714480
  714497
  722689
  723927
  733884
  733886
  741109
  760958
  777551
  788198
  791181
  800421
  820385
]
1.93 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал young сиськ"
]
1.88 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал young сиськ"
]
1.79 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal young tits"
]
1.74 ms
(0.92%)
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.