Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.20 ms
(82.85%)
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
  96393
  381853
  387123
  388426
  409027
  409253
  411745
  439813
  452379
  458623
  459828
  460340
  466954
  466982
  466996
  467036
  467043
  468886
  470388
  470763
  470779
  474125
  474656
  476341
  476856
  477200
  477707
  477718
  480291
  484157
  485741
  485751
  485762
  485774
  485942
  485950
  487946
  488937
  498722
  502932
  503842
  504344
  504493
  505642
  505687
  505688
  505690
  506847
  510599
  511037
  511916
  513823
  514436
  515924
  516053
  517073
  518826
  518842
  518862
  518871
  518949
  519155
  519752
  521123
  521131
  524881
  524895
  525138
  526729
  526833
  528538
  534273
  540688
  543924
  544464
  544473
  545964
  545982
  549225
  550647
  559579
  561576
  562890
  562892
  563134
  567491
  572347
  573335
  579740
  582972
  593529
  593540
  598649
  598949
  601904
  610083
  663956
  667288
  667496
  668943
  681298
  712820
  726591
  728496
  735906
  741016
  759658
  780704
  780724
  799366
  808669
  812320
  814817
  825039
]
15.64 ms
(10.96%)
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
  598949
  780724
  780704
  726591
  735906
  759658
  96393
  388426
  524881
  485950
  502932
  504493
  521123
  467036
  411745
  814817
  825039
  466954
  485942
  474656
  477718
  485751
  513823
  518826
  511037
  518871
  534273
  515924
  503842
  505690
  545964
  582972
  544464
  667496
  667288
  681298
  712820
  593540
  808669
  741016
  728496
  381853
  409027
  476341
  468886
  470388
  518862
  485741
  488937
  387123
  409253
  452379
  487946
  480291
  458623
  506847
  505642
  505687
  510599
  579740
  559579
  562892
  563134
  668943
  567491
  812320
  799366
  470763
  460340
  470779
  518842
  485762
  485774
  518949
  519752
  459828
  466996
  526729
  525138
  505688
  545982
  550647
  562890
  572347
  543924
  544473
  593529
  610083
  439813
  511916
  519155
  484157
  467043
  524895
  517073
  526833
  477200
  573335
  663956
  498722
  466982
  477707
  540688
  476856
  504344
  514436
  561576
  528538
  516053
  601904
  521131
  598649
  474125
  549225
]
2.30 ms
(1.61%)
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
  96393
  381853
  387123
  388426
  409027
  409253
  411745
  439813
  452379
  458623
  459828
  460340
  466954
  466982
  466996
  467036
  467043
  468886
  470388
  470763
  470779
  474125
  474656
  476341
  476856
  477200
  477707
  477718
  480291
  484157
  485741
  485751
  485762
  485774
  485942
  485950
  487946
  488937
  498722
  502932
  503842
  504344
  504493
  505642
  505687
  505688
  505690
  506847
  510599
  511037
  511916
  513823
  514436
  515924
  516053
  517073
  518826
  518842
  518862
  518871
  518949
  519155
  519752
  521123
  521131
  524881
  524895
  525138
  526729
  526833
  528538
  534273
  540688
  543924
  544464
  544473
  545964
  545982
  549225
  550647
  559579
  561576
  562890
  562892
  563134
  567491
  572347
  573335
  579740
  582972
  593529
  593540
  598649
  598949
  601904
  610083
  663956
  667288
  667496
  668943
  681298
  712820
  726591
  728496
  735906
  741016
  759658
  780704
  780724
  799366
  808669
  812320
  814817
  825039
]
1.79 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "granny черноволосая"
]
1.74 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "granny brunette"
]
1.58 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "granny черноволосая"
]

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.