Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.64 ms
(81.74%)
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
  383436
  388198
  393770
  394103
  396825
  400460
  416099
  417542
  419174
  420869
  421808
  423815
  424186
  424560
  428595
  428596
  432723
  433898
  436423
  441698
  445756
  445784
  447735
  448622
  451050
  451139
  454355
  454652
  457761
  457850
  461654
  463501
  468188
  469016
  469797
  472132
  475391
  476935
  478140
  479507
  479756
  479878
  480523
  482494
  483506
  483517
  488079
  488454
  490065
  490250
  490562
  491936
  492456
  492499
  495673
  496044
  498874
  508864
  508947
  511081
  511141
  511367
  511683
  514411
  515590
  519428
  519691
  520329
  520817
  521901
  523153
  523934
  523940
  524759
  525541
  526415
  526609
  527366
  527886
  529156
  538071
  538295
  543907
  546021
  547706
  548850
  550463
  557665
  564423
  567409
  568097
  574099
  574930
  575496
  575753
  576060
  578333
  587931
  588277
  591340
  595868
  606910
  610825
  610833
  620597
  621982
  622249
  632014
  643488
  654200
  661571
  694415
  699628
  732029
  739517
  760809
  773474
  805286
  820335
  824406
]
17.90 ms
(11.20%)
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
  483506
  511081
  511141
  511367
  520817
  521901
  527886
  383436
  396825
  417542
  436423
  419174
  433898
  432723
  428595
  428596
  824406
  820335
  482494
  488454
  457850
  472132
  490065
  469016
  492499
  495673
  520329
  511683
  538071
  498874
  524759
  538295
  463501
  475391
  479507
  543907
  548850
  557665
  574099
  578333
  546021
  564423
  567409
  575496
  575753
  576060
  661571
  699628
  654200
  694415
  547706
  550463
  568097
  574930
  591340
  606910
  610825
  610833
  621982
  632014
  588277
  622249
  643488
  587931
  595868
  805286
  739517
  732029
  760809
  773474
  620597
  400460
  441698
  447735
  454355
  457761
  469797
  480523
  393770
  424186
  445784
  476935
  478140
  479756
  479878
  394103
  421808
  461654
  388198
  416099
  420869
  423815
  445756
  451050
  454652
  424560
  448622
  451139
  468188
  508864
  515590
  519428
  519691
  523153
  526609
  483517
  490250
  490562
  492456
  508947
  523934
  523940
  525541
  526415
  527366
  529156
  488079
  491936
  496044
  514411
]
4.09 ms
(2.56%)
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
  383436
  388198
  393770
  394103
  396825
  400460
  416099
  417542
  419174
  420869
  421808
  423815
  424186
  424560
  428595
  428596
  432723
  433898
  436423
  441698
  445756
  445784
  447735
  448622
  451050
  451139
  454355
  454652
  457761
  457850
  461654
  463501
  468188
  469016
  469797
  472132
  475391
  476935
  478140
  479507
  479756
  479878
  480523
  482494
  483506
  483517
  488079
  488454
  490065
  490250
  490562
  491936
  492456
  492499
  495673
  496044
  498874
  508864
  508947
  511081
  511141
  511367
  511683
  514411
  515590
  519428
  519691
  520329
  520817
  521901
  523153
  523934
  523940
  524759
  525541
  526415
  526609
  527366
  527886
  529156
  538071
  538295
  543907
  546021
  547706
  548850
  550463
  557665
  564423
  567409
  568097
  574099
  574930
  575496
  575753
  576060
  578333
  587931
  588277
  591340
  595868
  606910
  610825
  610833
  620597
  621982
  622249
  632014
  643488
  654200
  661571
  694415
  699628
  732029
  739517
  760809
  773474
  805286
  820335
  824406
]
2.10 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая girlfriend"
]
1.80 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая girlfriend"
]
1.70 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful girlfriend"
]
1.59 ms
(0.99%)
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.