Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.22 ms
(87.12%)
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
  381921
  386303
  415818
  418832
  420280
  420638
  425173
  427027
  427166
  434763
  434933
  435005
  449385
  450441
  451173
  452036
  453344
  454801
  455006
  455217
  462850
  466772
  468142
  468537
  469221
  471081
  474425
  479661
  480197
  482780
  485527
  488295
  500335
  502826
  506516
  508903
  514042
  514399
  516030
  524047
  524564
  526069
  527405
  532778
  541776
  544680
  560665
  564856
  566346
  569927
  577034
  582489
  583734
  584351
  593847
  602631
  604060
  605688
  608174
  608773
  612061
  616382
  624838
  629287
  631878
  631981
  635432
  643100
  657136
  670210
  683446
  693378
  693944
  693965
  696202
  705099
  709723
  716087
  717606
  718698
  718766
  720740
  728145
  729843
  736684
  740012
  743354
  748285
  748616
  748997
  750701
  751572
  765364
  765559
  765680
  770382
  775683
  775855
  776940
  777942
  778941
  780025
  782894
  785614
  785645
  785871
  789188
  795206
  795471
  798443
  801610
  802263
  805983
  806580
  806688
  817359
  821851
  826253
  826610
  827335
]
16.50 ms
(7.80%)
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
  577034
  736684
  386303
  532778
  720740
  479661
  541776
  566346
  602631
  434763
  454801
  584351
  696202
  657136
  709723
  593847
  785871
  775683
  775855
  778941
  785614
  798443
  728145
  608773
  776940
  434933
  435005
  508903
  469221
  582489
  471081
  500335
  514399
  420280
  705099
  718766
  564856
  629287
  805983
  806688
  751572
  635432
  488295
  502826
  777942
  743354
  729843
  795471
  827335
  452036
  381921
  482780
  806580
  608174
  631981
  631878
  449385
  468142
  474425
  569927
  718698
  616382
  643100
  717606
  789188
  583734
  526069
  462850
  560665
  427027
  604060
  821851
  485527
  506516
  693944
  693965
  801610
  516030
  524047
  780025
  468537
  415818
  670210
  782894
  624838
  683446
  527405
  612061
  605688
  418832
  750701
  466772
  455217
  544680
  770382
  427166
  514042
  826253
  765559
  748997
  817359
  748285
  765680
  524564
  693378
  425173
  716087
  453344
  455006
  451173
  802263
  740012
  748616
  765364
  785645
  420638
  450441
  480197
  826610
  795206
]
2.89 ms
(1.37%)
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
  381921
  386303
  415818
  418832
  420280
  420638
  425173
  427027
  427166
  434763
  434933
  435005
  449385
  450441
  451173
  452036
  453344
  454801
  455006
  455217
  462850
  466772
  468142
  468537
  469221
  471081
  474425
  479661
  480197
  482780
  485527
  488295
  500335
  502826
  506516
  508903
  514042
  514399
  516030
  524047
  524564
  526069
  527405
  532778
  541776
  544680
  560665
  564856
  566346
  569927
  577034
  582489
  583734
  584351
  593847
  602631
  604060
  605688
  608174
  608773
  612061
  616382
  624838
  629287
  631878
  631981
  635432
  643100
  657136
  670210
  683446
  693378
  693944
  693965
  696202
  705099
  709723
  716087
  717606
  718698
  718766
  720740
  728145
  729843
  736684
  740012
  743354
  748285
  748616
  748997
  750701
  751572
  765364
  765559
  765680
  770382
  775683
  775855
  776940
  777942
  778941
  780025
  782894
  785614
  785645
  785871
  789188
  795206
  795471
  798443
  801610
  802263
  805983
  806580
  806688
  817359
  821851
  826253
  826610
  827335
]
2.26 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade tattoo squirt"
]
1.97 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск татуированные сквирт оргазм"
]
1.75 ms
(0.83%)
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.