Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.42 ms
(83.04%)
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
  247954
  395679
  401616
  403464
  407531
  418759
  433656
  445064
  450663
  464388
  465047
  485125
  489158
  496802
  506281
  509185
  513131
  519170
  523049
  526175
  531929
  540478
  546638
  550897
  554991
  555176
  555503
  561510
  564103
  564263
  564265
  565632
  565650
  565778
  574417
  587566
  593562
  604958
  610062
  611413
  612335
  612923
  616915
  623804
  626353
  626533
  630651
  633204
  637400
  658826
  673791
  697219
  700064
  709276
  713503
  716218
  716288
  716294
  724094
  726466
  726471
  726472
  726477
  726500
  726512
  726533
  726537
  726550
  726707
  726708
  726820
  726821
  726839
  730069
  730364
  731341
  735022
  742895
  743003
  744777
  746486
  749330
  750091
  759691
  759724
  759886
  760999
  761017
  762766
  765438
  765648
  766652
  766808
  767271
  776995
  785802
  788282
  788576
  792133
  792184
  795551
  796166
  796219
  797228
  801240
  801338
  801618
  802487
  804010
  809846
  811728
  814582
  815884
  815912
  816596
  820683
  823466
  824037
  824227
  826135
]
16.14 ms
(10.36%)
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
  824227
  814582
  815912
  815884
  816596
  823466
  824037
  826135
  450663
  465047
  509185
  526175
  519170
  531929
  555503
  564103
  554991
  713503
  700064
  716288
  716294
  658826
  709276
  716218
  546638
  550897
  587566
  630651
  593562
  611413
  612923
  626533
  776995
  809846
  785802
  801338
  811728
  724094
  726500
  743003
  744777
  749330
  765438
  788282
  792184
  795551
  796166
  796219
  801618
  802487
  804010
  730069
  759886
  766652
  766808
  726820
  726821
  730364
  742895
  762766
  726471
  731341
  735022
  746486
  750091
  760999
  761017
  604958
  610062
  623804
  697219
  792133
  797228
  247954
  489158
  395679
  401616
  418759
  407531
  433656
  445064
  820683
  485125
  464388
  513131
  506281
  561510
  565632
  574417
  564265
  673791
  555176
  564263
  565650
  565778
  616915
  626353
  637400
  633204
  801240
  788576
  726707
  759691
  726472
  726512
  726533
  726537
  726708
  726839
  765648
  767271
  726466
  726477
  726550
  759724
  403464
  523049
  540478
  496802
  612335
]
2.83 ms
(1.82%)
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
  247954
  395679
  401616
  403464
  407531
  418759
  433656
  445064
  450663
  464388
  465047
  485125
  489158
  496802
  506281
  509185
  513131
  519170
  523049
  526175
  531929
  540478
  546638
  550897
  554991
  555176
  555503
  561510
  564103
  564263
  564265
  565632
  565650
  565778
  574417
  587566
  593562
  604958
  610062
  611413
  612335
  612923
  616915
  623804
  626353
  626533
  630651
  633204
  637400
  658826
  673791
  697219
  700064
  709276
  713503
  716218
  716288
  716294
  724094
  726466
  726471
  726472
  726477
  726500
  726512
  726533
  726537
  726550
  726707
  726708
  726820
  726821
  726839
  730069
  730364
  731341
  735022
  742895
  743003
  744777
  746486
  749330
  750091
  759691
  759724
  759886
  760999
  761017
  762766
  765438
  765648
  766652
  766808
  767271
  776995
  785802
  788282
  788576
  792133
  792184
  795551
  796166
  796219
  797228
  801240
  801338
  801618
  802487
  804010
  809846
  811728
  814582
  815884
  815912
  816596
  820683
  823466
  824037
  824227
  826135
]
2.21 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature latina"
]
1.93 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature латинская"
]
1.68 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.05%)
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.