Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.65 ms
(80.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
  29367
  96200
  191509
  311163
  385710
  386918
  388739
  389391
  392266
  393582
  395142
  395583
  402312
  411347
  411533
  419140
  421617
  424438
  427050
  431487
  449744
  451092
  451150
  457120
  457897
  458036
  460764
  464239
  466029
  467376
  467659
  468344
  471914
  473115
  474584
  476429
  481286
  483968
  487556
  488329
  494732
  496347
  497670
  499832
  500043
  502269
  505851
  517613
  520917
  521369
  521902
  526124
  534155
  536012
  543080
  551812
  552045
  556703
  557263
  558372
  558832
  559726
  563523
  563648
  565630
  566704
  566889
  576375
  579103
  589512
  594442
  597530
  598751
  600064
  601763
  602438
  603955
  610139
  612030
  621811
  622064
  622665
  625819
  628345
  634905
  646061
  649024
  650277
  656400
  656472
  663000
  667906
  670411
  673118
  675795
  678260
  681142
  686648
  709916
  717918
  720631
  724312
  732986
  739120
  752754
  753031
  756838
  760609
  765381
  768933
  773158
  773817
  775828
  782710
  792899
  800275
  800406
  800562
  803839
  814371
]
21.01 ms
(12.89%)
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
  481286
  395583
  473115
  466029
  488329
  521902
  96200
  494732
  775828
  29367
  520917
  385710
  392266
  388739
  389391
  419140
  431487
  497670
  534155
  517613
  579103
  650277
  678260
  686648
  656472
  552045
  566889
  601763
  612030
  800275
  521369
  393582
  421617
  464239
  457897
  451092
  536012
  499832
  557263
  551812
  565630
  649024
  667906
  681142
  646061
  663000
  709916
  720631
  634905
  621811
  610139
  792899
  800406
  753031
  782710
  803839
  752754
  756838
  768933
  732986
  765381
  773158
  739120
  760609
  773817
  625819
  386918
  468344
  191509
  411533
  467659
  476429
  427050
  458036
  460764
  451150
  487556
  483968
  395142
  311163
  814371
  589512
  457120
  502269
  496347
  500043
  526124
  563648
  543080
  556703
  558372
  559726
  563523
  576375
  558832
  566704
  673118
  675795
  656400
  670411
  717918
  594442
  600064
  598751
  602438
  603955
  622064
  597530
  622665
  628345
  800562
  724312
  402312
  424438
  474584
  411347
  471914
  449744
  467376
  505851
]
3.13 ms
(1.92%)
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
  29367
  96200
  191509
  311163
  385710
  386918
  388739
  389391
  392266
  393582
  395142
  395583
  402312
  411347
  411533
  419140
  421617
  424438
  427050
  431487
  449744
  451092
  451150
  457120
  457897
  458036
  460764
  464239
  466029
  467376
  467659
  468344
  471914
  473115
  474584
  476429
  481286
  483968
  487556
  488329
  494732
  496347
  497670
  499832
  500043
  502269
  505851
  517613
  520917
  521369
  521902
  526124
  534155
  536012
  543080
  551812
  552045
  556703
  557263
  558372
  558832
  559726
  563523
  563648
  565630
  566704
  566889
  576375
  579103
  589512
  594442
  597530
  598751
  600064
  601763
  602438
  603955
  610139
  612030
  621811
  622064
  622665
  625819
  628345
  634905
  646061
  649024
  650277
  656400
  656472
  663000
  667906
  670411
  673118
  675795
  678260
  681142
  686648
  709916
  717918
  720631
  724312
  732986
  739120
  752754
  753031
  756838
  760609
  765381
  768933
  773158
  773817
  775828
  782710
  792899
  800275
  800406
  800562
  803839
  814371
]
2.42 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс трах пальцем"
]
2.20 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс секс пальц"
]
1.71 ms
(1.05%)
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.