Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.79 ms
(82.13%)
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
  25030
  32874
  33401
  37057
  96342
  111339
  126637
  379330
  382788
  384541
  385373
  386758
  386840
  388094
  389978
  390318
  395504
  396594
  397958
  398528
  401115
  414088
  415872
  419126
  446340
  446345
  446352
  446698
  449592
  464344
  477801
  478498
  483576
  485161
  489276
  516666
  516750
  516770
  517605
  528875
  530729
  530911
  534986
  534993
  535083
  535816
  536309
  536578
  537837
  544694
  545359
  552951
  553282
  561265
  565104
  566656
  568543
  573934
  587928
  591893
  599957
  604588
  605449
  613079
  617429
  623964
  629279
  630873
  633972
  637785
  640723
  643934
  644246
  665361
  673767
  673776
  684106
  686034
  687594
  692495
  693153
  693219
  694476
  694908
  700678
  712887
  714830
  715068
  715551
  719955
  720015
  720025
  720061
  721065
  722187
  723376
  725171
  732888
  738241
  742428
  744656
  745037
  746837
  749152
  750884
  789187
  797387
  806121
  810355
  810709
  813799
  814661
  814667
  817786
  820849
  821698
  822279
  822888
  822990
  824900
]
17.94 ms
(10.62%)
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
  566656
  591893
  446698
  386758
  587928
  599957
  749152
  385373
  379330
  25030
  389978
  396594
  820849
  478498
  489276
  537837
  565104
  673776
  720061
  694908
  623964
  644246
  746837
  797387
  806121
  604588
  637785
  390318
  384541
  126637
  822888
  822990
  821698
  822279
  535083
  517605
  528875
  536578
  561265
  573934
  665361
  692495
  684106
  693219
  720015
  687594
  694476
  715068
  629279
  630873
  643934
  738241
  810355
  750884
  732888
  700678
  719955
  789187
  96342
  446340
  530729
  530911
  534986
  534993
  516750
  553282
  568543
  640723
  617429
  516770
  386840
  111339
  37057
  32874
  388094
  419126
  414088
  415872
  817786
  813799
  814661
  814667
  824900
  446345
  477801
  483576
  536309
  535816
  464344
  544694
  552951
  545359
  673767
  686034
  720025
  721065
  723376
  693153
  712887
  722187
  613079
  725171
  745037
  744656
  714830
  715551
  810709
  446352
  395504
  401115
  33401
  382788
  397958
  398528
  485161
  449592
  516666
  633972
  742428
  605449
]
4.08 ms
(2.41%)
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
  25030
  32874
  33401
  37057
  96342
  111339
  126637
  379330
  382788
  384541
  385373
  386758
  386840
  388094
  389978
  390318
  395504
  396594
  397958
  398528
  401115
  414088
  415872
  419126
  446340
  446345
  446352
  446698
  449592
  464344
  477801
  478498
  483576
  485161
  489276
  516666
  516750
  516770
  517605
  528875
  530729
  530911
  534986
  534993
  535083
  535816
  536309
  536578
  537837
  544694
  545359
  552951
  553282
  561265
  565104
  566656
  568543
  573934
  587928
  591893
  599957
  604588
  605449
  613079
  617429
  623964
  629279
  630873
  633972
  637785
  640723
  643934
  644246
  665361
  673767
  673776
  684106
  686034
  687594
  692495
  693153
  693219
  694476
  694908
  700678
  712887
  714830
  715068
  715551
  719955
  720015
  720025
  720061
  721065
  722187
  723376
  725171
  732888
  738241
  742428
  744656
  745037
  746837
  749152
  750884
  789187
  797387
  806121
  810355
  810709
  813799
  814661
  814667
  817786
  820849
  821698
  822279
  822888
  822990
  824900
]
2.44 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black cock bbc"
]
2.03 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black cock bbc"
]
1.96 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black cock bbc"
]

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.