Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.09 ms
(84.38%)
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
  225591
  382115
  397420
  398057
  409274
  414104
  414269
  414430
  415878
  416571
  423814
  423819
  439584
  443340
  445107
  446778
  447553
  451863
  454052
  456312
  460451
  473719
  478985
  479867
  480788
  485966
  493849
  494216
  509019
  514254
  514339
  515060
  520911
  522295
  525204
  527866
  531638
  535319
  546028
  553215
  555599
  561961
  562587
  563419
  568864
  576128
  577105
  580176
  580182
  583796
  584355
  586563
  586975
  587244
  588436
  588449
  589522
  602467
  602627
  604412
  607142
  618329
  636183
  642048
  643451
  651008
  658907
  658952
  661653
  663968
  668628
  689036
  690666
  692718
  695464
  697878
  699963
  706410
  706446
  706705
  712184
  719461
  722273
  736581
  740694
  742409
  744046
  759114
  761246
  762222
  762673
  773605
  777668
  780357
  780412
  786932
  787716
  790109
  791385
  794669
  795389
  796509
  799161
  801374
  801576
  806010
  806468
  807244
  808335
  808971
  809811
  812542
  813819
  814459
  817875
  821634
  823009
  823884
  823887
  824102
]
16.51 ms
(9.73%)
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
  643451
  618329
  780357
  808335
  806010
  712184
  485966
  563419
  668628
  522295
  493849
  414104
  415878
  561961
  588436
  602467
  478985
  382115
  479867
  515060
  661653
  397420
  409274
  577105
  692718
  787716
  740694
  809811
  447553
  473719
  509019
  821634
  651008
  697878
  736581
  773605
  801374
  423819
  814459
  535319
  580176
  568864
  695464
  706446
  719461
  555599
  636183
  586975
  602627
  604412
  607142
  812542
  794669
  796509
  799161
  762222
  762673
  791385
  807244
  514339
  824102
  584355
  589522
  806468
  786932
  642048
  706705
  777668
  451863
  398057
  823884
  494216
  562587
  744046
  576128
  658952
  416571
  446778
  658907
  689036
  553215
  588449
  443340
  586563
  454052
  445107
  525204
  527866
  813819
  823009
  699963
  706410
  587244
  780412
  761246
  790109
  414430
  583796
  690666
  795389
  801576
  742409
  759114
  460451
  663968
  480788
  439584
  456312
  823887
  531638
  722273
  808971
  225591
  520911
  414269
  423814
  817875
  514254
  580182
  546028
]
2.71 ms
(1.60%)
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
  225591
  382115
  397420
  398057
  409274
  414104
  414269
  414430
  415878
  416571
  423814
  423819
  439584
  443340
  445107
  446778
  447553
  451863
  454052
  456312
  460451
  473719
  478985
  479867
  480788
  485966
  493849
  494216
  509019
  514254
  514339
  515060
  520911
  522295
  525204
  527866
  531638
  535319
  546028
  553215
  555599
  561961
  562587
  563419
  568864
  576128
  577105
  580176
  580182
  583796
  584355
  586563
  586975
  587244
  588436
  588449
  589522
  602467
  602627
  604412
  607142
  618329
  636183
  642048
  643451
  651008
  658907
  658952
  661653
  663968
  668628
  689036
  690666
  692718
  695464
  697878
  699963
  706410
  706446
  706705
  712184
  719461
  722273
  736581
  740694
  742409
  744046
  759114
  761246
  762222
  762673
  773605
  777668
  780357
  780412
  786932
  787716
  790109
  791385
  794669
  795389
  796509
  799161
  801374
  801576
  806010
  806468
  807244
  808335
  808971
  809811
  812542
  813819
  814459
  817875
  821634
  823009
  823884
  823887
  824102
]
1.85 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo in bathroom"
]
1.82 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дилд ван"
]
1.77 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.