Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.87 ms
(82.92%)
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
  326039
  381940
  385104
  395556
  411833
  419544
  419594
  420540
  430923
  439569
  452045
  454206
  458715
  459620
  462557
  465342
  465860
  466181
  466897
  468934
  474108
  474391
  475080
  477185
  477715
  478446
  484470
  484584
  485695
  486581
  490944
  491209
  495420
  496056
  502002
  502029
  502718
  502743
  503961
  505107
  509206
  512999
  520696
  523902
  524987
  525484
  534851
  535532
  536586
  539480
  546939
  549767
  549964
  556842
  557540
  557998
  561131
  563434
  571240
  575815
  576651
  576678
  581383
  584810
  585958
  590850
  593743
  595842
  595992
  599327
  605576
  606791
  619482
  628693
  646833
  650494
  661568
  663501
  664833
  665384
  668943
  673365
  681857
  684934
  689012
  724479
  726552
  726836
  727022
  729091
  729217
  730934
  735376
  737167
  737180
  737863
  741738
  742860
  743811
  744632
  748239
  748892
  755468
  756816
  759877
  775890
  785434
  790218
  793703
  796271
  801210
  801356
  802107
  802741
  803081
  804194
  807332
  807760
  811182
  820679
]
16.56 ms
(10.33%)
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
  807760
  729217
  730934
  748892
  724479
  737180
  737863
  755468
  735376
  756816
  775890
  785434
  802107
  804194
  811182
  462557
  419594
  458715
  459620
  549767
  557540
  576651
  681857
  575815
  606791
  790218
  381940
  505107
  520696
  486581
  395556
  326039
  439569
  820679
  474108
  478446
  452045
  534851
  535532
  539480
  556842
  584810
  557998
  646833
  650494
  661568
  663501
  664833
  665384
  684934
  673365
  689012
  546939
  549964
  563434
  599327
  595842
  595992
  619482
  801210
  801356
  807332
  803081
  737167
  759877
  726552
  744632
  742860
  743811
  726836
  727022
  793703
  802741
  419544
  466181
  430923
  502002
  509206
  496056
  512999
  475080
  477185
  524987
  502743
  668943
  590850
  503961
  502029
  485695
  748239
  420540
  465342
  465860
  523902
  502718
  468934
  628693
  477715
  466897
  491209
  490944
  385104
  796271
  729091
  741738
  411833
  484470
  474391
  484584
  454206
  525484
  536586
  495420
  576678
  561131
  581383
  571240
  605576
  585958
  593743
]
3.53 ms
(2.20%)
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
  326039
  381940
  385104
  395556
  411833
  419544
  419594
  420540
  430923
  439569
  452045
  454206
  458715
  459620
  462557
  465342
  465860
  466181
  466897
  468934
  474108
  474391
  475080
  477185
  477715
  478446
  484470
  484584
  485695
  486581
  490944
  491209
  495420
  496056
  502002
  502029
  502718
  502743
  503961
  505107
  509206
  512999
  520696
  523902
  524987
  525484
  534851
  535532
  536586
  539480
  546939
  549767
  549964
  556842
  557540
  557998
  561131
  563434
  571240
  575815
  576651
  576678
  581383
  584810
  585958
  590850
  593743
  595842
  595992
  599327
  605576
  606791
  619482
  628693
  646833
  650494
  661568
  663501
  664833
  665384
  668943
  673365
  681857
  684934
  689012
  724479
  726552
  726836
  727022
  729091
  729217
  730934
  735376
  737167
  737180
  737863
  741738
  742860
  743811
  744632
  748239
  748892
  755468
  756816
  759877
  775890
  785434
  790218
  793703
  796271
  801210
  801356
  802107
  802741
  803081
  804194
  807332
  807760
  811182
  820679
]
2.07 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "kissing зрелая женщин"
]
2.01 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "kissing mature woman"
]
1.63 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "kissing зрелая женщин"
]

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.