Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.41 ms
(84.35%)
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
  130289
  161528
  187962
  188262
  188293
  191048
  213692
  280674
  312264
  313978
  381435
  383584
  384540
  385582
  387905
  390871
  391386
  394652
  395661
  399628
  401146
  401985
  404078
  404762
  407885
  409060
  409934
  411808
  412261
  414125
  415151
  416121
  417384
  419130
  419503
  419617
  422673
  423500
  424001
  424421
  425353
  428407
  428817
  442626
  443782
  444145
  446872
  451960
  455579
  455945
  460811
  462348
  463743
  464179
  464237
  464921
  465958
  466228
  466267
  468718
  469321
  470923
  472895
  474104
  475968
  476323
  478036
  480296
  480302
  482299
  482314
  485100
  485870
  491228
  495396
  496873
  504481
  513220
  516480
  517069
  520176
  521764
  523834
  523835
  523838
  523845
  523867
  525393
  526526
  526527
  526528
  531900
  532560
  534553
  535005
  536939
  541336
  546973
  549036
  549221
  569003
  569147
  572031
  578208
  589573
  591333
  600276
  609229
  639755
  669223
  680977
  716765
  728540
  786523
  797949
  801949
  808341
  814049
  814429
  821219
]
18.06 ms
(9.93%)
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
  546973
  728540
  475968
  517069
  523835
  187962
  485100
  504481
  525393
  468718
  387905
  412261
  464179
  385582
  130289
  390871
  442626
  417384
  419617
  451960
  532560
  478036
  680977
  716765
  569147
  600276
  609229
  786523
  419130
  455579
  404762
  424001
  460811
  416121
  465958
  526528
  516480
  409934
  480296
  496873
  549221
  474104
  444145
  466267
  428817
  443782
  523845
  526526
  591333
  280674
  549036
  401985
  428407
  446872
  520176
  535005
  669223
  797949
  801949
  425353
  414125
  422673
  464237
  464921
  391386
  469321
  495396
  466228
  541336
  188262
  409060
  463743
  491228
  482314
  531900
  415151
  523867
  485870
  523838
  523834
  526527
  313978
  808341
  384540
  383584
  213692
  161528
  394652
  401146
  188293
  462348
  424421
  476323
  395661
  404078
  407885
  821219
  639755
  470923
  312264
  399628
  482299
  521764
  480302
  578208
  536939
  191048
  814429
  455945
  472895
  569003
  572031
  589573
  419503
  381435
  411808
  423500
  814049
  534553
  513220
]
3.02 ms
(1.66%)
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
  130289
  161528
  187962
  188262
  188293
  191048
  213692
  280674
  312264
  313978
  381435
  383584
  384540
  385582
  387905
  390871
  391386
  394652
  395661
  399628
  401146
  401985
  404078
  404762
  407885
  409060
  409934
  411808
  412261
  414125
  415151
  416121
  417384
  419130
  419503
  419617
  422673
  423500
  424001
  424421
  425353
  428407
  428817
  442626
  443782
  444145
  446872
  451960
  455579
  455945
  460811
  462348
  463743
  464179
  464237
  464921
  465958
  466228
  466267
  468718
  469321
  470923
  472895
  474104
  475968
  476323
  478036
  480296
  480302
  482299
  482314
  485100
  485870
  491228
  495396
  496873
  504481
  513220
  516480
  517069
  520176
  521764
  523834
  523835
  523838
  523845
  523867
  525393
  526526
  526527
  526528
  531900
  532560
  534553
  535005
  536939
  541336
  546973
  549036
  549221
  569003
  569147
  572031
  578208
  589573
  591333
  600276
  609229
  639755
  669223
  680977
  716765
  728540
  786523
  797949
  801949
  808341
  814049
  814429
  821219
]
2.14 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature blonde anal"
]
1.93 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature беловолосая анал"
]
1.54 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature беловолосая анал"
]

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.