Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.47 ms
(86.74%)
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
  31602
  280493
  335978
  382141
  382480
  383171
  385148
  387925
  389346
  390949
  391528
  396790
  398911
  408446
  416666
  420208
  443406
  447982
  448907
  465647
  522166
  529766
  529804
  530749
  532392
  533816
  533820
  536521
  536523
  537312
  537332
  543862
  544965
  545962
  547033
  548516
  553429
  555021
  565117
  565199
  567542
  567546
  574711
  575285
  575897
  576599
  577395
  578748
  593206
  601079
  612237
  618343
  618409
  624403
  634855
  634866
  634868
  637978
  643051
  645693
  648111
  648579
  651253
  658991
  665374
  667234
  675534
  680630
  687206
  694394
  707360
  714169
  714176
  714180
  714399
  715267
  715268
  715419
  715448
  720915
  725518
  728074
  728238
  729076
  732247
  734073
  736760
  737569
  740172
  740955
  740964
  742024
  743784
  745312
  747363
  751502
  762565
  769410
  771634
  774098
  776244
  776733
  778486
  781966
  788049
  788319
  789545
  792820
  795260
  797124
  797314
  800414
  803063
  803219
  804506
  805320
  806312
  806359
  811865
  812791
]
12.15 ms
(7.20%)
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
  728074
  715448
  612237
  382141
  389346
  536521
  522166
  529804
  544965
  565117
  567542
  601079
  593206
  789545
  803063
  806359
  762565
  725518
  747363
  715419
  812791
  465647
  776244
  771634
  447982
  745312
  390949
  634866
  729076
  545962
  797124
  737569
  732247
  416666
  385148
  31602
  408446
  795260
  728238
  443406
  420208
  448907
  533820
  537332
  547033
  548516
  565199
  694394
  714176
  714399
  714169
  714180
  651253
  707360
  715267
  555021
  618343
  624403
  634855
  634868
  643051
  778486
  788049
  803219
  804506
  811865
  736760
  805320
  740172
  769410
  774098
  742024
  751502
  788319
  806312
  776733
  792820
  734073
  781966
  800414
  536523
  383171
  575285
  396790
  530749
  533816
  537312
  553429
  575897
  574711
  576599
  578748
  645693
  648579
  687206
  648111
  665374
  675534
  680630
  567546
  637978
  740955
  740964
  743784
  797314
  387925
  391528
  532392
  658991
  715268
  577395
  335978
  280493
  382480
  398911
  529766
  543862
  720915
  667234
  618409
]
2.67 ms
(1.58%)
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
  31602
  280493
  335978
  382141
  382480
  383171
  385148
  387925
  389346
  390949
  391528
  396790
  398911
  408446
  416666
  420208
  443406
  447982
  448907
  465647
  522166
  529766
  529804
  530749
  532392
  533816
  533820
  536521
  536523
  537312
  537332
  543862
  544965
  545962
  547033
  548516
  553429
  555021
  565117
  565199
  567542
  567546
  574711
  575285
  575897
  576599
  577395
  578748
  593206
  601079
  612237
  618343
  618409
  624403
  634855
  634866
  634868
  637978
  643051
  645693
  648111
  648579
  651253
  658991
  665374
  667234
  675534
  680630
  687206
  694394
  707360
  714169
  714176
  714180
  714399
  715267
  715268
  715419
  715448
  720915
  725518
  728074
  728238
  729076
  732247
  734073
  736760
  737569
  740172
  740955
  740964
  742024
  743784
  745312
  747363
  751502
  762565
  769410
  771634
  774098
  776244
  776733
  778486
  781966
  788049
  788319
  789545
  792820
  795260
  797124
  797314
  800414
  803063
  803219
  804506
  805320
  806312
  806359
  811865
  812791
]
2.09 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð┐ð¥ÐÇð¢ð¥ ð¥ð│ÐÇð¥ð╝ð¢ÐïðÁ Ðüð©ÐüÐîð║ðÔÔǪ"
]
2.01 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "порн огромные сиськ"
]
1.72 ms
(1.02%)
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.