Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.80 ms
(85.82%)
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
  3512
  131653
  150461
  156877
  182735
  187709
  187986
  230974
  382555
  382791
  383952
  385640
  387610
  388315
  390696
  391756
  391890
  392446
  392632
  392665
  393063
  393856
  393868
  396388
  418007
  420194
  432470
  432975
  437977
  443010
  443870
  447137
  453507
  454062
  457895
  459730
  462887
  464630
  468420
  469206
  474605
  479000
  480966
  487786
  488457
  496813
  498966
  499047
  500621
  514046
  516023
  516160
  523390
  524531
  527668
  527712
  530629
  532254
  533230
  534601
  543123
  551588
  551597
  551674
  567057
  571948
  580137
  584509
  588439
  589554
  592646
  594626
  599002
  600208
  601463
  605770
  632070
  638194
  656079
  668666
  669689
  691411
  704983
  706211
  710255
  710282
  717159
  720015
  737303
  746964
  747756
  748609
  750844
  750864
  758563
  758780
  760226
  760400
  768358
  769452
  770937
  776271
  777579
  778590
  778756
  778841
  781021
  782908
  784299
  790097
  790444
  794337
  795948
  796695
  800583
  806403
  806873
  809851
  812935
  825384
]
13.95 ms
(8.44%)
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
  589554
  601463
  800583
  806403
  795948
  796695
  769452
  747756
  737303
  768358
  790444
  392446
  393063
  390696
  532254
  393868
  382555
  3512
  396388
  706211
  669689
  656079
  594626
  600208
  776271
  777579
  781021
  812935
  760226
  750844
  746964
  750864
  638194
  794337
  182735
  391890
  516023
  516160
  496813
  488457
  580137
  599002
  605770
  443010
  453507
  524531
  187709
  391756
  387610
  443870
  487786
  500621
  551674
  571948
  567057
  447137
  468420
  479000
  420194
  437977
  464630
  499047
  527712
  530629
  514046
  385640
  382791
  187986
  392632
  418007
  454062
  480966
  457895
  462887
  474605
  523390
  498966
  534601
  551597
  543123
  691411
  584509
  632070
  588439
  806873
  758780
  760400
  748609
  758563
  710282
  778841
  392665
  432470
  469206
  388315
  527668
  770937
  383952
  150461
  131653
  156877
  230974
  393856
  432975
  825384
  459730
  533230
  551588
  704983
  710255
  720015
  668666
  717159
  592646
  778756
  790097
  809851
  778590
  782908
  784299
]
3.05 ms
(1.85%)
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
  3512
  131653
  150461
  156877
  182735
  187709
  187986
  230974
  382555
  382791
  383952
  385640
  387610
  388315
  390696
  391756
  391890
  392446
  392632
  392665
  393063
  393856
  393868
  396388
  418007
  420194
  432470
  432975
  437977
  443010
  443870
  447137
  453507
  454062
  457895
  459730
  462887
  464630
  468420
  469206
  474605
  479000
  480966
  487786
  488457
  496813
  498966
  499047
  500621
  514046
  516023
  516160
  523390
  524531
  527668
  527712
  530629
  532254
  533230
  534601
  543123
  551588
  551597
  551674
  567057
  571948
  580137
  584509
  588439
  589554
  592646
  594626
  599002
  600208
  601463
  605770
  632070
  638194
  656079
  668666
  669689
  691411
  704983
  706211
  710255
  710282
  717159
  720015
  737303
  746964
  747756
  748609
  750844
  750864
  758563
  758780
  760226
  760400
  768358
  769452
  770937
  776271
  777579
  778590
  778756
  778841
  781021
  782908
  784299
  790097
  790444
  794337
  795948
  796695
  800583
  806403
  806873
  809851
  812935
  825384
]
1.95 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тату раком"
]
1.62 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "татуированные рак"
]
1.45 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "татуированные рак"
]
1.41 ms
(0.85%)
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.