Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.51 ms
(81.48%)
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
  181851
  187775
  340567
  352187
  390924
  391327
  400726
  410694
  414372
  429069
  429555
  432997
  434307
  435794
  437248
  441120
  444391
  444915
  447936
  448464
  448758
  450670
  450977
  452373
  458675
  468975
  470198
  471128
  471148
  473437
  473887
  476514
  477198
  477366
  477809
  482383
  482541
  483738
  485297
  490501
  501951
  505242
  510176
  510324
  511012
  511365
  511528
  511534
  511866
  513569
  514369
  514408
  515089
  515452
  516640
  517710
  519661
  520492
  520963
  521110
  521343
  523131
  523381
  523568
  523875
  523975
  524117
  524306
  524310
  525399
  525968
  526292
  526833
  527574
  527884
  528000
  528005
  528009
  529741
  531822
  531852
  531856
  533600
  537141
  537250
  539470
  541487
  552343
  554582
  554742
  556483
  557975
  559377
  559796
  560825
  564984
  567860
  568802
  569281
  598388
  598882
  604105
  605862
  609136
  615022
  620086
  625783
  626089
  629962
  642004
  696591
  745083
  777416
  786444
  793151
  796333
  796706
  796716
  806910
  810772
]
17.67 ms
(12.05%)
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
  564984
  598388
  448758
  514369
  510324
  527884
  559377
  448464
  452373
  485297
  450670
  615022
  437248
  569281
  525399
  527574
  429555
  447936
  515452
  501951
  568802
  471128
  517710
  625783
  523381
  786444
  806910
  432997
  470198
  477198
  477366
  523975
  533600
  528009
  554582
  458675
  524306
  511012
  187775
  520492
  526292
  629962
  523568
  567860
  513569
  519661
  400726
  537250
  557975
  515089
  521343
  524117
  626089
  810772
  777416
  390924
  521110
  528000
  468975
  505242
  510176
  541487
  473887
  434307
  524310
  477809
  528005
  444915
  511365
  523131
  554742
  490501
  556483
  482541
  520963
  482383
  560825
  552343
  476514
  429069
  523875
  514408
  414372
  525968
  609136
  526833
  511528
  511534
  450977
  435794
  444391
  605862
  620086
  559796
  539470
  340567
  598882
  796706
  473437
  604105
  352187
  441120
  391327
  796716
  410694
  516640
  529741
  537141
  696591
  642004
  511866
  181851
  531852
  531822
  531856
  745083
  471148
  793151
  796333
  483738
]
2.87 ms
(1.96%)
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
  181851
  187775
  340567
  352187
  390924
  391327
  400726
  410694
  414372
  429069
  429555
  432997
  434307
  435794
  437248
  441120
  444391
  444915
  447936
  448464
  448758
  450670
  450977
  452373
  458675
  468975
  470198
  471128
  471148
  473437
  473887
  476514
  477198
  477366
  477809
  482383
  482541
  483738
  485297
  490501
  501951
  505242
  510176
  510324
  511012
  511365
  511528
  511534
  511866
  513569
  514369
  514408
  515089
  515452
  516640
  517710
  519661
  520492
  520963
  521110
  521343
  523131
  523381
  523568
  523875
  523975
  524117
  524306
  524310
  525399
  525968
  526292
  526833
  527574
  527884
  528000
  528005
  528009
  529741
  531822
  531852
  531856
  533600
  537141
  537250
  539470
  541487
  552343
  554582
  554742
  556483
  557975
  559377
  559796
  560825
  564984
  567860
  568802
  569281
  598388
  598882
  604105
  605862
  609136
  615022
  620086
  625783
  626089
  629962
  642004
  696591
  745083
  777416
  786444
  793151
  796333
  796706
  796716
  806910
  810772
]
1.92 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "большая жопа и дилдо"
]
1.87 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие жоп дилд"
]
1.27 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.