Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.22 ms
(84.04%)
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
  375092
  391976
  392100
  398144
  403624
  405699
  413637
  416018
  417267
  418894
  420226
  423475
  424615
  428473
  430520
  432681
  437708
  438940
  439146
  440087
  441077
  441901
  443230
  443784
  444271
  444431
  444794
  445468
  448551
  449126
  449397
  452850
  452873
  452879
  452948
  453002
  453154
  453170
  453216
  453373
  455084
  455134
  456019
  456245
  457476
  462223
  462921
  463978
  464494
  466934
  467715
  469617
  469741
  470195
  470493
  471929
  471982
  473439
  476932
  477055
  480103
  484710
  494547
  497909
  499389
  499887
  501676
  507626
  508908
  510945
  514854
  515307
  520797
  530436
  536375
  539741
  542926
  543989
  546059
  547484
  547546
  554674
  556906
  568809
  571401
  577471
  579145
  579381
  583476
  583558
  588175
  589243
  590552
  608603
  611164
  653475
  666988
  667077
  668650
  692750
  697460
  700509
  703915
  714727
  714889
  722420
  746125
  752663
  774878
  782891
  793127
  796682
  796794
  797280
  800930
  804159
  804641
  806321
  812598
  814519
]
17.07 ms
(10.38%)
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
  453154
  453216
  456245
  507626
  510945
  514854
  530436
  462921
  571401
  568809
  577471
  666988
  667077
  703915
  714727
  554674
  589243
  608603
  588175
  590552
  804641
  774878
  793127
  797280
  746125
  782891
  800930
  752663
  611164
  697460
  714889
  796682
  796794
  804159
  806321
  812598
  391976
  392100
  470195
  403624
  443230
  453002
  470493
  432681
  437708
  444271
  455134
  471929
  417267
  444794
  520797
  443784
  473439
  375092
  398144
  405699
  438940
  441077
  441901
  424615
  440087
  444431
  416018
  418894
  423475
  439146
  413637
  420226
  428473
  430520
  814519
  445468
  448551
  453373
  455084
  463978
  469741
  449397
  452873
  452879
  452948
  457476
  471982
  449126
  452850
  453170
  456019
  462223
  466934
  469617
  476932
  499389
  499887
  501676
  515307
  539741
  494547
  536375
  497909
  508908
  464494
  467715
  477055
  480103
  484710
  542926
  547484
  547546
  556906
  579381
  543989
  546059
  583558
  579145
  583476
  692750
  700509
  722420
  653475
  668650
]
2.49 ms
(1.52%)
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
  375092
  391976
  392100
  398144
  403624
  405699
  413637
  416018
  417267
  418894
  420226
  423475
  424615
  428473
  430520
  432681
  437708
  438940
  439146
  440087
  441077
  441901
  443230
  443784
  444271
  444431
  444794
  445468
  448551
  449126
  449397
  452850
  452873
  452879
  452948
  453002
  453154
  453170
  453216
  453373
  455084
  455134
  456019
  456245
  457476
  462223
  462921
  463978
  464494
  466934
  467715
  469617
  469741
  470195
  470493
  471929
  471982
  473439
  476932
  477055
  480103
  484710
  494547
  497909
  499389
  499887
  501676
  507626
  508908
  510945
  514854
  515307
  520797
  530436
  536375
  539741
  542926
  543989
  546059
  547484
  547546
  554674
  556906
  568809
  571401
  577471
  579145
  579381
  583476
  583558
  588175
  589243
  590552
  608603
  611164
  653475
  666988
  667077
  668650
  692750
  697460
  700509
  703915
  714727
  714889
  722420
  746125
  752663
  774878
  782891
  793127
  796682
  796794
  797280
  800930
  804159
  804641
  806321
  812598
  814519
]
2.12 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "муж и игрушка"
]
1.87 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен игрушк"
]
1.33 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.