Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.75 ms
(85.66%)
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
  383049
  385141
  385480
  385963
  391277
  398744
  399036
  404383
  405831
  409941
  411459
  412134
  422192
  423855
  423948
  434338
  439749
  440629
  443836
  444078
  446450
  451115
  457096
  457313
  457603
  458031
  458080
  458882
  460489
  461828
  461919
  469009
  470860
  472198
  483024
  485439
  486233
  487820
  488157
  490250
  492088
  492410
  493042
  496236
  499054
  501681
  502885
  504313
  509867
  510769
  510884
  510930
  511596
  512066
  512216
  512480
  514264
  515065
  516023
  518506
  519577
  520549
  520729
  523435
  525584
  526494
  527983
  533631
  538199
  538971
  540988
  546864
  552867
  555984
  558327
  560266
  584453
  585330
  588956
  590265
  592178
  592979
  593935
  596898
  597568
  601355
  603059
  604660
  607181
  611517
  617214
  621160
  621186
  622777
  631701
  634671
  657780
  662454
  675071
  675126
  681539
  684704
  694142
  697457
  701936
  711569
  720645
  725514
  733480
  738175
  739557
  741504
  742636
  761039
  761097
  766337
  788810
  789915
  791916
  819262
]
15.79 ms
(9.21%)
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
  486233
  601355
  585330
  597568
  733480
  725514
  766337
  622777
  621186
  657780
  662454
  711569
  788810
  720645
  523435
  399036
  515065
  739557
  558327
  701936
  761097
  409941
  819262
  552867
  634671
  516023
  684704
  444078
  603059
  596898
  518506
  457603
  675126
  631701
  492088
  510930
  584453
  383049
  443836
  512066
  560266
  411459
  509867
  488157
  789915
  493042
  458882
  607181
  492410
  694142
  423855
  446450
  741504
  458031
  434338
  742636
  510884
  504313
  761039
  451115
  385480
  791916
  423948
  617214
  398744
  738175
  457313
  499054
  697457
  385963
  611517
  458080
  525584
  496236
  538199
  604660
  460489
  675071
  422192
  391277
  588956
  538971
  546864
  593935
  555984
  527983
  502885
  440629
  457096
  461828
  412134
  439749
  510769
  519577
  405831
  385141
  540988
  681539
  533631
  404383
  590265
  511596
  526494
  520549
  472198
  592178
  512216
  520729
  514264
  621160
  469009
  501681
  470860
  483024
  485439
  592979
  461919
  490250
  512480
  487820
]
2.83 ms
(1.65%)
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
  383049
  385141
  385480
  385963
  391277
  398744
  399036
  404383
  405831
  409941
  411459
  412134
  422192
  423855
  423948
  434338
  439749
  440629
  443836
  444078
  446450
  451115
  457096
  457313
  457603
  458031
  458080
  458882
  460489
  461828
  461919
  469009
  470860
  472198
  483024
  485439
  486233
  487820
  488157
  490250
  492088
  492410
  493042
  496236
  499054
  501681
  502885
  504313
  509867
  510769
  510884
  510930
  511596
  512066
  512216
  512480
  514264
  515065
  516023
  518506
  519577
  520549
  520729
  523435
  525584
  526494
  527983
  533631
  538199
  538971
  540988
  546864
  552867
  555984
  558327
  560266
  584453
  585330
  588956
  590265
  592178
  592979
  593935
  596898
  597568
  601355
  603059
  604660
  607181
  611517
  617214
  621160
  621186
  622777
  631701
  634671
  657780
  662454
  675071
  675126
  681539
  684704
  694142
  697457
  701936
  711569
  720645
  725514
  733480
  738175
  739557
  741504
  742636
  761039
  761097
  766337
  788810
  789915
  791916
  819262
]
1.55 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy style sex"
]
1.51 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак style секс"
]
1.43 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак style секс"
]

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.