Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.19 ms
(82.14%)
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
  189743
  199188
  358193
  385386
  385638
  385991
  390150
  391546
  394439
  397219
  398551
  398567
  400807
  403376
  411627
  411998
  419145
  443142
  443770
  444117
  452379
  453100
  453122
  454225
  454267
  454408
  455026
  455910
  457303
  462085
  462095
  462106
  462315
  462562
  463171
  463803
  463825
  464535
  465363
  466989
  466997
  467043
  469360
  469453
  474104
  474826
  474874
  475039
  475080
  475298
  476257
  476260
  476312
  480480
  480745
  485733
  485752
  485981
  486835
  491109
  494282
  498722
  499112
  503801
  506049
  508420
  516053
  516137
  517238
  518774
  518864
  518869
  519143
  519151
  522594
  525492
  525511
  526843
  529400
  537837
  538826
  545897
  546084
  548065
  549222
  549239
  549245
  550636
  550652
  554449
  558286
  565931
  567083
  567427
  567731
  574257
  574384
  580667
  591265
  598649
  599732
  603342
  607132
  615631
  664956
  665195
  665513
  666811
  667294
  667684
  678778
  678790
  678791
  678804
  724290
  736765
  743767
  760176
  781978
  801053
]
17.57 ms
(11.72%)
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
  529400
  549222
  554449
  567731
  666811
  462106
  465363
  455026
  462562
  580667
  486835
  508420
  558286
  463171
  526843
  550636
  598649
  199188
  453122
  464535
  567083
  391546
  538826
  548065
  443142
  475039
  574257
  462095
  474826
  474874
  463803
  475080
  476257
  463825
  476260
  485733
  518774
  466997
  565931
  567427
  607132
  480480
  519151
  485752
  519143
  518864
  518869
  358193
  469453
  665513
  736765
  397219
  615631
  467043
  546084
  419145
  474104
  457303
  411998
  516137
  455910
  522594
  525492
  678791
  453100
  400807
  454225
  454267
  462315
  506049
  189743
  403376
  537837
  550652
  667294
  591265
  801053
  724290
  743767
  398551
  411627
  462085
  385638
  394439
  476312
  485981
  494282
  678804
  525511
  466989
  499112
  516053
  443770
  480745
  549245
  678778
  678790
  498722
  452379
  385991
  398567
  545897
  664956
  665195
  667684
  599732
  781978
  760176
  385386
  390150
  491109
  574384
  549239
  444117
  503801
  475298
  517238
  469360
  454408
  603342
]
2.70 ms
(1.80%)
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
  189743
  199188
  358193
  385386
  385638
  385991
  390150
  391546
  394439
  397219
  398551
  398567
  400807
  403376
  411627
  411998
  419145
  443142
  443770
  444117
  452379
  453100
  453122
  454225
  454267
  454408
  455026
  455910
  457303
  462085
  462095
  462106
  462315
  462562
  463171
  463803
  463825
  464535
  465363
  466989
  466997
  467043
  469360
  469453
  474104
  474826
  474874
  475039
  475080
  475298
  476257
  476260
  476312
  480480
  480745
  485733
  485752
  485981
  486835
  491109
  494282
  498722
  499112
  503801
  506049
  508420
  516053
  516137
  517238
  518774
  518864
  518869
  519143
  519151
  522594
  525492
  525511
  526843
  529400
  537837
  538826
  545897
  546084
  548065
  549222
  549239
  549245
  550636
  550652
  554449
  558286
  565931
  567083
  567427
  567731
  574257
  574384
  580667
  591265
  598649
  599732
  603342
  607132
  615631
  664956
  665195
  665513
  666811
  667294
  667684
  678778
  678790
  678791
  678804
  724290
  736765
  743767
  760176
  781978
  801053
]
1.75 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "полная бабушк в"
]
1.70 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"полненькие бабушки вÑ%…"
]
1.59 ms
(1.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.