Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.37 ms
(85.03%)
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
  388552
  421259
  423498
  426635
  435233
  444728
  450639
  474889
  484464
  485887
  486261
  491648
  492155
  493090
  495726
  498332
  501104
  508832
  508865
  508929
  510822
  511090
  514752
  515980
  516452
  516844
  517223
  524110
  530306
  531583
  532806
  534221
  535585
  538269
  540089
  540200
  540317
  541579
  543657
  543671
  546820
  546825
  548671
  548900
  550895
  552000
  556511
  559179
  559185
  559194
  562786
  563876
  566791
  569769
  569770
  570918
  572219
  573256
  574663
  575075
  576055
  576081
  576281
  576836
  580592
  580673
  582644
  582985
  583562
  584023
  589928
  593463
  593502
  594553
  603564
  620843
  629966
  643593
  651944
  653561
  669433
  673039
  677920
  679564
  680137
  680172
  690144
  706929
  725619
  734413
  738032
  739799
  739871
  749317
  765593
  772061
  773315
  785944
  789323
  790197
  791757
  795061
  795385
  797029
  797204
  799784
  802516
  805013
  805172
  807971
  808475
  810414
  810846
  813805
  817057
  819554
  820410
  823330
  825629
]
17.46 ms
(9.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
  426635
  423498
  813805
  819554
  492155
  535585
  516452
  546820
  679564
  791757
  773315
  739871
  566791
  580592
  772061
  531583
  511090
  680137
  495726
  580673
  493090
  559185
  576081
  534221
  541579
  546825
  677920
  584023
  593463
  785944
  450639
  540200
  569770
  388552
  797204
  738032
  524110
  570918
  669433
  510822
  795385
  515980
  576836
  653561
  573256
  786867
  765593
  435233
  484464
  540317
  563876
  583562
  620843
  643593
  795061
  444728
  486261
  538269
  501104
  543657
  576055
  552000
  559179
  548900
  575075
  593502
  603564
  589928
  799784
  805172
  808475
  790197
  673039
  651944
  823330
  532806
  540089
  516844
  572219
  582985
  802516
  810414
  629966
  797029
  550895
  680172
  574663
  576281
  508865
  517223
  514752
  508929
  548671
  562786
  530306
  485887
  690144
  807971
  789323
  734413
  594553
  556511
  725619
  543671
  491648
  559194
  810846
  569769
  825629
  820410
  817057
  498332
  582644
  706929
  805013
  739799
  749317
  421259
  474889
  508832
]
2.34 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк бдсм"
]
2.33 ms
(1.25%)
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
  388552
  421259
  423498
  426635
  435233
  444728
  450639
  474889
  484464
  485887
  486261
  491648
  492155
  493090
  495726
  498332
  501104
  508832
  508865
  508929
  510822
  511090
  514752
  515980
  516452
  516844
  517223
  524110
  530306
  531583
  532806
  534221
  535585
  538269
  540089
  540200
  540317
  541579
  543657
  543671
  546820
  546825
  548671
  548900
  550895
  552000
  556511
  559179
  559185
  559194
  562786
  563876
  566791
  569769
  569770
  570918
  572219
  573256
  574663
  575075
  576055
  576081
  576281
  576836
  580592
  580673
  582644
  582985
  583562
  584023
  589928
  593463
  593502
  594553
  603564
  620843
  629966
  643593
  651944
  653561
  669433
  673039
  677920
  679564
  680137
  680172
  690144
  706929
  725619
  734413
  738032
  739799
  739871
  749317
  765593
  772061
  773315
  785944
  789323
  790197
  791757
  795061
  795385
  797029
  797204
  799784
  802516
  805013
  805172
  807971
  808475
  810414
  810846
  813805
  817057
  819554
  820410
  823330
  825629
]
2.13 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl bondage"
]
1.92 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк бдсм"
]
1.69 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.