Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
378.48 ms
(93.27%)
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
  61243
  209726
  327981
  389144
  390987
  391993
  396111
  401415
  404090
  408355
  409126
  410677
  418544
  419045
  423963
  426600
  427540
  428993
  429603
  429888
  437791
  439233
  444615
  446508
  450852
  458435
  459163
  464582
  465250
  468937
  469035
  469594
  469994
  470015
  471194
  472535
  473453
  476184
  476214
  477344
  477590
  479703
  481734
  483558
  483754
  486645
  495144
  496702
  496711
  500327
  504903
  510024
  513789
  526169
  528139
  531818
  534612
  538206
  541589
  545965
  546577
  546723
  546838
  547039
  547565
  549794
  549797
  550899
  551829
  553765
  555485
  556890
  557617
  560674
  562126
  563934
  565627
  569020
  573908
  574147
  575424
  576314
  576742
  577961
  579384
  582010
  586086
  592605
  592617
  593053
  602025
  614350
  619792
  623458
  624220
  665128
  665271
  666141
  667525
  678834
  695887
  704227
  713876
  720421
  721486
  724281
  732930
  734276
  735658
  742765
  748727
  748982
  752188
  754256
  754426
  807301
  807341
  809736
  810945
  819547
]
17.60 ms
(4.34%)
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
  510024
  546723
  541589
  614350
  468937
  619792
  396111
  574147
  560674
  748727
  479703
  563934
  582010
  469035
  734276
  742765
  391993
  469994
  486645
  754426
  752188
  534612
  553765
  458435
  459163
  555485
  483558
  819547
  531818
  469594
  565627
  667525
  720421
  665128
  704227
  665271
  666141
  602025
  748982
  810945
  724281
  624220
  809736
  419045
  477590
  546838
  713876
  592605
  592617
  732930
  464582
  427540
  528139
  426600
  545965
  557617
  735658
  754256
  721486
  496711
  576314
  586086
  61243
  404090
  418544
  465250
  547039
  409126
  538206
  576742
  439233
  477344
  593053
  401415
  437791
  389144
  410677
  471194
  446508
  569020
  623458
  807301
  429603
  476214
  390987
  408355
  495144
  496702
  546577
  549794
  551829
  483754
  428993
  429888
  470015
  473453
  476184
  577961
  327981
  450852
  472535
  513789
  526169
  678834
  807341
  481734
  504903
  209726
  444615
  423963
  500327
  549797
  575424
  547565
  562126
  579384
  550899
  695887
  556890
  573908
]
2.38 ms
(0.59%)
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
  61243
  209726
  327981
  389144
  390987
  391993
  396111
  401415
  404090
  408355
  409126
  410677
  418544
  419045
  423963
  426600
  427540
  428993
  429603
  429888
  437791
  439233
  444615
  446508
  450852
  458435
  459163
  464582
  465250
  468937
  469035
  469594
  469994
  470015
  471194
  472535
  473453
  476184
  476214
  477344
  477590
  479703
  481734
  483558
  483754
  486645
  495144
  496702
  496711
  500327
  504903
  510024
  513789
  526169
  528139
  531818
  534612
  538206
  541589
  545965
  546577
  546723
  546838
  547039
  547565
  549794
  549797
  550899
  551829
  553765
  555485
  556890
  557617
  560674
  562126
  563934
  565627
  569020
  573908
  574147
  575424
  576314
  576742
  577961
  579384
  582010
  586086
  592605
  592617
  593053
  602025
  614350
  619792
  623458
  624220
  665128
  665271
  666141
  667525
  678834
  695887
  704227
  713876
  720421
  721486
  724281
  732930
  734276
  735658
  742765
  748727
  748982
  752188
  754256
  754426
  807301
  807341
  809736
  810945
  819547
]
2.01 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public big toys"
]
1.99 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц большие toys"
]
1.73 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц большие toys"
]

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.