Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.08 ms
(81.01%)
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
  57971
  395634
  396337
  415802
  419324
  421524
  426279
  426968
  446142
  466852
  473655
  473918
  477801
  482486
  483451
  485403
  490245
  495011
  495585
  520207
  521258
  525569
  527727
  533401
  534469
  535071
  546025
  546400
  570147
  578716
  588404
  599539
  603458
  605494
  606869
  615246
  616594
  625972
  641134
  650998
  651314
  672281
  675885
  695738
  696982
  709721
  710313
  710351
  712948
  713085
  720098
  720775
  724078
  724322
  726623
  728218
  729082
  729217
  732592
  732717
  732760
  732793
  733278
  733556
  738888
  739901
  740002
  740663
  744234
  751007
  751845
  755462
  756429
  762766
  765911
  766334
  770417
  770959
  773971
  776968
  777917
  781772
  782428
  783454
  784917
  785119
  787907
  788798
  791498
  793664
  794588
  795752
  795779
  795840
  795895
  796164
  796288
  799091
  800685
  801122
  801760
  802028
  802059
  802284
  802652
  803202
  810026
  811382
  811546
  812380
  814115
  817048
  817725
  817887
  819952
  820156
  820339
  821809
  824803
  824804
]
20.97 ms
(12.67%)
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
  783454
  793664
  794588
  795840
  795895
  801122
  801760
  810026
  732760
  740663
  755462
  765911
  770417
  724322
  751845
  726623
  728218
  732717
  738888
  739901
  751007
  762766
  732592
  773971
  606869
  709721
  710313
  712948
  777917
  784917
  787907
  791498
  795752
  796288
  802284
  57971
  395634
  396337
  415802
  720098
  599539
  776968
  803202
  740002
  729082
  811382
  588404
  824803
  820156
  675885
  710351
  720775
  603458
  795779
  812380
  724078
  733556
  733278
  713085
  419324
  696982
  744234
  615246
  421524
  426279
  817725
  495011
  534469
  672281
  695738
  616594
  605494
  781772
  766334
  729217
  732793
  756429
  782428
  785119
  788798
  802059
  473918
  446142
  473655
  483451
  525569
  466852
  625972
  802028
  800685
  770959
  796164
  802652
  641134
  799091
  811546
  426968
  817887
  821809
  824804
  814115
  817048
  820339
  819952
  482486
  477801
  485403
  490245
  535071
  495585
  527727
  533401
  520207
  521258
  546025
  578716
  546400
  570147
  650998
  651314
]
3.44 ms
(2.08%)
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
  57971
  395634
  396337
  415802
  419324
  421524
  426279
  426968
  446142
  466852
  473655
  473918
  477801
  482486
  483451
  485403
  490245
  495011
  495585
  520207
  521258
  525569
  527727
  533401
  534469
  535071
  546025
  546400
  570147
  578716
  588404
  599539
  603458
  605494
  606869
  615246
  616594
  625972
  641134
  650998
  651314
  672281
  675885
  695738
  696982
  709721
  710313
  710351
  712948
  713085
  720098
  720775
  724078
  724322
  726623
  728218
  729082
  729217
  732592
  732717
  732760
  732793
  733278
  733556
  738888
  739901
  740002
  740663
  744234
  751007
  751845
  755462
  756429
  762766
  765911
  766334
  770417
  770959
  773971
  776968
  777917
  781772
  782428
  783454
  784917
  785119
  787907
  788798
  791498
  793664
  794588
  795752
  795779
  795840
  795895
  796164
  796288
  799091
  800685
  801122
  801760
  802028
  802059
  802284
  802652
  803202
  810026
  811382
  811546
  812380
  814115
  817048
  817725
  817887
  819952
  820156
  820339
  821809
  824803
  824804
]
2.07 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass husband"
]
1.74 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп husband"
]
1.48 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп husband"
]

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.