Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.03 ms
(81.12%)
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
  268222
  268747
  285233
  383774
  395236
  395335
  396556
  398261
  398477
  398513
  398695
  400480
  402346
  402762
  413273
  416826
  421851
  422154
  423908
  424038
  424446
  428610
  432647
  432735
  432736
  432878
  440745
  440877
  446061
  447521
  447690
  447732
  447804
  448951
  449141
  450344
  450889
  453727
  454600
  456236
  457890
  458420
  460299
  463156
  465986
  466007
  466261
  467948
  468105
  469565
  470968
  473222
  478644
  481748
  483567
  483568
  484193
  484763
  485086
  488454
  491920
  493568
  496077
  500922
  509063
  509818
  512935
  517662
  517768
  517797
  519063
  521552
  529709
  546005
  554252
  570160
  576933
  578327
  579746
  579848
  590843
  593768
  604373
  604426
  626256
  654338
  656206
  670906
  678868
  686457
  695719
  715566
  720598
  723573
  725619
  726974
  728706
  740248
  740589
  741296
  742341
  743578
  746378
  756089
  759370
  764186
  766830
  768760
  787492
  788837
  789664
  819005
  821089
  822086
  825943
  826067
  827589
  828198
  828788
]
17.99 ms
(11.96%)
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
  766830
  725619
  759370
  764186
  715566
  720598
  788837
  789664
  424038
  450344
  469565
  481748
  483567
  517662
  493568
  463156
  383774
  468105
  268747
  395335
  395236
  678868
  656206
  626256
  485086
  428610
  432647
  483568
  529709
  478644
  579746
  654338
  579848
  423908
  484193
  519063
  422154
  398261
  400480
  432735
  432736
  440877
  440745
  446061
  488454
  458420
  467948
  453727
  454600
  496077
  512935
  460299
  554252
  576933
  570160
  578327
  590843
  593768
  413273
  447690
  473222
  449141
  398695
  402762
  421851
  500922
  517797
  740248
  768760
  743578
  756089
  484763
  398477
  447521
  695719
  456236
  432878
  268222
  402346
  723573
  670906
  686457
  604373
  740583
  728706
  741296
  742341
  746378
  740589
  787492
  509063
  465986
  726974
  447804
  521552
  546005
  416826
  447732
  457890
  491920
  466007
  509818
  466261
  450889
  470968
  517768
  285233
  448951
  604426
  424446
  396556
  398513
  819005
  825943
  827589
  822086
  821089
  828198
  828788
  826067
]
2.73 ms
(1.81%)
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
  268222
  268747
  285233
  383774
  395236
  395335
  396556
  398261
  398477
  398513
  398695
  400480
  402346
  402762
  413273
  416826
  421851
  422154
  423908
  424038
  424446
  428610
  432647
  432735
  432736
  432878
  440745
  440877
  446061
  447521
  447690
  447732
  447804
  448951
  449141
  450344
  450889
  453727
  454600
  456236
  457890
  458420
  460299
  463156
  465986
  466007
  466261
  467948
  468105
  469565
  470968
  473222
  478644
  481748
  483567
  483568
  484193
  484763
  485086
  488454
  491920
  493568
  496077
  500922
  509063
  509818
  512935
  517662
  517768
  517797
  519063
  521552
  529709
  546005
  554252
  570160
  576933
  578327
  579746
  579848
  590843
  593768
  604373
  604426
  626256
  654338
  656206
  670906
  678868
  686457
  695719
  715566
  720598
  723573
  725619
  726974
  728706
  740248
  740589
  741296
  742341
  743578
  746378
  756089
  759370
  764186
  766830
  768760
  787492
  788837
  789664
  819005
  821089
  822086
  825943
  826067
  827589
  828198
  828788
]
2.20 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал через трусики"
]
2.05 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал трусик нижн бел"
]
1.74 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал трусик нижн бел"
]
1.70 ms
(1.13%)
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.