Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.34 ms
(83.81%)
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
  458277
  467225
  475966
  568753
  569105
  585956
  586967
  589191
  591223
  594780
  600521
  603554
  603838
  606804
  606970
  612388
  613400
  614379
  616524
  617261
  617382
  620642
  624816
  625328
  626398
  626473
  626501
  626623
  626853
  627268
  628342
  628685
  630767
  631024
  631073
  631352
  632330
  632938
  633071
  633381
  639229
  639381
  644705
  650408
  652283
  662158
  663416
  664681
  668939
  671446
  677337
  680485
  696246
  698603
  699564
  703807
  704127
  705220
  705769
  710194
  711342
  714914
  715379
  718301
  718588
  719437
  720158
  722081
  722142
  724078
  724596
  726217
  726999
  727293
  729097
  729694
  730118
  730457
  731766
  732101
  732208
  733030
  734522
  734966
  735525
  737005
  737051
  737572
  737933
  739160
  739188
  740699
  741183
  743756
  746942
  747366
  747372
  747383
  748055
  748697
  748941
  751247
  751868
  754220
  755112
  755174
  757185
  757239
  757712
  758977
  759131
  759346
  761615
  762168
  762560
  764264
  802788
  810152
  827567
]
14.53 ms
(10.38%)
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
  696246
  704127
  705769
  710194
  711342
  714914
  715379
  722081
  722142
  650408
  652283
  662158
  663416
  664681
  668939
  671446
  677337
  680485
  703807
  718301
  719437
  568753
  569105
  606804
  613400
  614379
  617261
  625328
  626473
  628685
  631073
  585956
  586967
  603554
  603838
  612388
  626398
  633071
  639381
  644705
  591223
  594780
  616524
  624816
  626623
  628342
  632330
  633381
  589191
  600521
  606970
  617382
  620642
  626501
  626853
  627268
  630767
  631024
  631352
  810152
  729694
  739188
  740699
  748055
  755112
  757239
  761615
  762560
  724078
  727293
  729097
  731766
  732208
  733030
  735525
  737005
  737572
  743756
  751247
  751868
  724596
  726217
  730457
  734966
  739160
  748697
  755174
  757712
  758977
  762168
  732101
  734522
  741183
  747366
  754220
  759346
  726999
  730118
  737051
  737933
  746942
  747372
  747383
  748941
  757185
  764264
  627511
  632938
  639229
  698603
  699564
  705220
  718588
  720158
  802788
  475966
  759131
  827567
  467225
  458277
]
2.00 ms
(1.43%)
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
  458277
  467225
  475966
  568753
  569105
  585956
  586967
  589191
  591223
  594780
  600521
  603554
  603838
  606804
  606970
  612388
  613400
  614379
  616524
  617261
  617382
  620642
  624816
  625328
  626398
  626473
  626501
  626623
  626853
  627268
  628342
  628685
  630767
  631024
  631073
  631352
  632330
  632938
  633071
  633381
  639229
  639381
  644705
  650408
  652283
  662158
  663416
  664681
  668939
  671446
  677337
  680485
  696246
  698603
  699564
  703807
  704127
  705220
  705769
  710194
  711342
  714914
  715379
  718301
  718588
  719437
  720158
  722081
  722142
  724078
  724596
  726217
  726999
  727293
  729097
  729694
  730118
  730457
  731766
  732101
  732208
  733030
  734522
  734966
  735525
  737005
  737051
  737572
  737933
  739160
  739188
  740699
  741183
  743756
  746942
  747366
  747372
  747383
  748055
  748697
  748941
  751247
  751868
  754220
  755112
  755174
  757185
  757239
  757712
  758977
  759131
  759346
  761615
  762168
  762560
  764264
  802788
  810152
  827567
]
1.85 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation dick"
]
1.52 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац член"
]
1.37 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.