Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
197.19 ms
(86.44%)
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
  2332
  28591
  76122
  382488
  382585
  383173
  389897
  391269
  395392
  395413
  397714
  401589
  403628
  409010
  412367
  413253
  416082
  417395
  420130
  420507
  420864
  423787
  425609
  427540
  430508
  432266
  433950
  437347
  437791
  437833
  454853
  455509
  455696
  457378
  459466
  460211
  460488
  460653
  460767
  461079
  461625
  462596
  469055
  472312
  473985
  474904
  480968
  481154
  483243
  487417
  489857
  490809
  491514
  492516
  493469
  496519
  499433
  505191
  506301
  512927
  520555
  520576
  520706
  521760
  523818
  527195
  542096
  548701
  551370
  552073
  552148
  552624
  560341
  560469
  567538
  567770
  569689
  572630
  575426
  582526
  586803
  592418
  597231
  598033
  599317
  603679
  604086
  623442
  625395
  626863
  628589
  629752
  649507
  668964
  676388
  676483
  680517
  699459
  704261
  709306
  711600
  715402
  722913
  726954
  735800
  773414
  775288
  776191
  783206
  788132
  792322
  795674
  797095
  797867
  798177
  799689
  800231
  810568
  813728
  819932
]
20.16 ms
(8.84%)
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
  2332
  412367
  520576
  520555
  699459
  649507
  704261
  432266
  462596
  417395
  603679
  813728
  569689
  722913
  629752
  625395
  490809
  413253
  455696
  567770
  582526
  542096
  423787
  457378
  427540
  460211
  483243
  521760
  527195
  437347
  506301
  416082
  487417
  735800
  726954
  783206
  382488
  623442
  776191
  425609
  788132
  461079
  496519
  819932
  668964
  680517
  775288
  792322
  76122
  604086
  799689
  795674
  469055
  512927
  797867
  401589
  382585
  592418
  493469
  709306
  567538
  430508
  599317
  474904
  676483
  800231
  773414
  810568
  395413
  420864
  551370
  575426
  676388
  715402
  552148
  586803
  433950
  397714
  461625
  520706
  491514
  572630
  798177
  391269
  437833
  492516
  460653
  560341
  628589
  626863
  499433
  420130
  383173
  454853
  523818
  548701
  711600
  797095
  28591
  395392
  481154
  472312
  597231
  389897
  480968
  460767
  459466
  473985
  437791
  460488
  505191
  403628
  420507
  455509
  489857
  552624
  560469
  552073
  598033
  409010
]
3.17 ms
(1.39%)
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
  2332
  28591
  76122
  382488
  382585
  383173
  389897
  391269
  395392
  395413
  397714
  401589
  403628
  409010
  412367
  413253
  416082
  417395
  420130
  420507
  420864
  423787
  425609
  427540
  430508
  432266
  433950
  437347
  437791
  437833
  454853
  455509
  455696
  457378
  459466
  460211
  460488
  460653
  460767
  461079
  461625
  462596
  469055
  472312
  473985
  474904
  480968
  481154
  483243
  487417
  489857
  490809
  491514
  492516
  493469
  496519
  499433
  505191
  506301
  512927
  520555
  520576
  520706
  521760
  523818
  527195
  542096
  548701
  551370
  552073
  552148
  552624
  560341
  560469
  567538
  567770
  569689
  572630
  575426
  582526
  586803
  592418
  597231
  598033
  599317
  603679
  604086
  623442
  625395
  626863
  628589
  629752
  649507
  668964
  676388
  676483
  680517
  699459
  704261
  709306
  711600
  715402
  722913
  726954
  735800
  773414
  775288
  776191
  783206
  788132
  792322
  795674
  797095
  797867
  798177
  799689
  800231
  810568
  813728
  819932
]
2.04 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая сиськ секс"
]
1.86 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful tits sex"
]
1.85 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.