Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.22 ms
(87.66%)
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
  96463
  388422
  389451
  393531
  396482
  400005
  413125
  413805
  452204
  458238
  482615
  515270
  521860
  529623
  537593
  545218
  545251
  550595
  557630
  562998
  563691
  565902
  574964
  576511
  578166
  581275
  593919
  612098
  613435
  618600
  624989
  629169
  629472
  631884
  633435
  634585
  635073
  635325
  643612
  653319
  655163
  655683
  656363
  662474
  662522
  668105
  678572
  681663
  684823
  686148
  687040
  689857
  696058
  705067
  713683
  714808
  717955
  718134
  718143
  722408
  723522
  726263
  727589
  728887
  730052
  730362
  736987
  737049
  740181
  742674
  743157
  744726
  745434
  745513
  753189
  754401
  757987
  762748
  764290
  765909
  768301
  768826
  770069
  770423
  771418
  779918
  781368
  781748
  782401
  785984
  789487
  790407
  791475
  793245
  793797
  794901
  795016
  796074
  798345
  798920
  800729
  801372
  801616
  801947
  803435
  803953
  805334
  808240
  811087
  811965
  815677
  817020
  819137
  821187
  821388
  822848
  823750
  824913
  825249
  825708
]
12.98 ms
(7.10%)
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
  413125
  822848
  817020
  821388
  458238
  452204
  521860
  515270
  578166
  689857
  696058
  714808
  681663
  718143
  655163
  655683
  668105
  718134
  618600
  791475
  798345
  779918
  789487
  811087
  727589
  728887
  740181
  764290
  801947
  726263
  745434
  762748
  793797
  811965
  393531
  389451
  823750
  825249
  821187
  824913
  819137
  482615
  529623
  563691
  545251
  545218
  662522
  687040
  653319
  550595
  613435
  631884
  635325
  793245
  800729
  801616
  736987
  771418
  795016
  768301
  742674
  770423
  730052
  743157
  629169
  413805
  396482
  633435
  400005
  723522
  825708
  815677
  581275
  557630
  574964
  562998
  565902
  656363
  684823
  717955
  686148
  662474
  713683
  576511
  593919
  634585
  624989
  612098
  643612
  781748
  785984
  790407
  794901
  801372
  805334
  808240
  781368
  803435
  737049
  753189
  768826
  782401
  803953
  745513
  730362
  754401
  765909
  770069
  757987
  744726
  629472
  635073
  705067
  722408
  796074
  798920
  96463
  388422
  678572
  537593
]
3.13 ms
(1.71%)
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
  96463
  388422
  389451
  393531
  396482
  400005
  413125
  413805
  452204
  458238
  482615
  515270
  521860
  529623
  537593
  545218
  545251
  550595
  557630
  562998
  563691
  565902
  574964
  576511
  578166
  581275
  593919
  612098
  613435
  618600
  624989
  629169
  629472
  631884
  633435
  634585
  635073
  635325
  643612
  653319
  655163
  655683
  656363
  662474
  662522
  668105
  678572
  681663
  684823
  686148
  687040
  689857
  696058
  705067
  713683
  714808
  717955
  718134
  718143
  722408
  723522
  726263
  727589
  728887
  730052
  730362
  736987
  737049
  740181
  742674
  743157
  744726
  745434
  745513
  753189
  754401
  757987
  762748
  764290
  765909
  768301
  768826
  770069
  770423
  771418
  779918
  781368
  781748
  782401
  785984
  789487
  790407
  791475
  793245
  793797
  794901
  795016
  796074
  798345
  798920
  800729
  801372
  801616
  801947
  803435
  803953
  805334
  808240
  811087
  811965
  815677
  817020
  819137
  821187
  821388
  822848
  823750
  824913
  825249
  825708
]
1.95 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "love fuck"
]
1.68 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "love секс"
]
1.53 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.27 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "love секс"
]

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.