Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.98 ms
(84.94%)
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
  86568
  386198
  397663
  397687
  400540
  422010
  455639
  460827
  464269
  477578
  479070
  482059
  483758
  493328
  496140
  501155
  504242
  512390
  512398
  514197
  520855
  529629
  530461
  531332
  531575
  531648
  531665
  531674
  531726
  531972
  532175
  532181
  532388
  532402
  532633
  533078
  533162
  533180
  533208
  533225
  533317
  533666
  535194
  535653
  535806
  535844
  536079
  536113
  536144
  536856
  537166
  537189
  537641
  538040
  538476
  538493
  538789
  538799
  539180
  539384
  540417
  540935
  541137
  541917
  541932
  542245
  542246
  542571
  542618
  542647
  543271
  546251
  548832
  551693
  553868
  555147
  557719
  575900
  579057
  588562
  592280
  594052
  600659
  604037
  604487
  628489
  631003
  631009
  633430
  633918
  634190
  634616
  636894
  640671
  642125
  644086
  645481
  665897
  707415
  719742
  723024
  726258
  727288
  732164
  733256
  733361
  735311
  736981
  737326
  738400
  739882
  752854
  757639
  761686
  761718
  769710
  772037
  782050
  783386
  823174
]
12.14 ms
(8.12%)
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
  529629
  530461
  531575
  531972
  532175
  533078
  533666
  535844
  537189
  537641
  538476
  538493
  501155
  531648
  531726
  532181
  532633
  533208
  533225
  535806
  536113
  536144
  539384
  540417
  496140
  504242
  512398
  520855
  531665
  531674
  532388
  532402
  533162
  533180
  533317
  535194
  535653
  536079
  536856
  538040
  538789
  538799
  539180
  460827
  464269
  479070
  483758
  493328
  542245
  542618
  542647
  540935
  541917
  541932
  543271
  557719
  575900
  542571
  546251
  548832
  551693
  555147
  645481
  719742
  665897
  553868
  579057
  588562
  628489
  634190
  636894
  600659
  642125
  644086
  594052
  631003
  592280
  604037
  631009
  633430
  633918
  634616
  640671
  782050
  737326
  761686
  772037
  783386
  735311
  726258
  727288
  733361
  752854
  769710
  732164
  738400
  757639
  739882
  761718
  604487
  723024
  397687
  397663
  400540
  422010
  823174
  477578
  512390
  514197
  531332
  537166
  541137
  542246
  733256
  736981
  707415
  386198
  86568
  455639
  482059
]
3.10 ms
(2.07%)
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
  86568
  386198
  397663
  397687
  400540
  422010
  455639
  460827
  464269
  477578
  479070
  482059
  483758
  493328
  496140
  501155
  504242
  512390
  512398
  514197
  520855
  529629
  530461
  531332
  531575
  531648
  531665
  531674
  531726
  531972
  532175
  532181
  532388
  532402
  532633
  533078
  533162
  533180
  533208
  533225
  533317
  533666
  535194
  535653
  535806
  535844
  536079
  536113
  536144
  536856
  537166
  537189
  537641
  538040
  538476
  538493
  538789
  538799
  539180
  539384
  540417
  540935
  541137
  541917
  541932
  542245
  542246
  542571
  542618
  542647
  543271
  546251
  548832
  551693
  553868
  555147
  557719
  575900
  579057
  588562
  592280
  594052
  600659
  604037
  604487
  628489
  631003
  631009
  633430
  633918
  634190
  634616
  636894
  640671
  642125
  644086
  645481
  665897
  707415
  719742
  723024
  726258
  727288
  732164
  733256
  733361
  735311
  736981
  737326
  738400
  739882
  752854
  757639
  761686
  761718
  769710
  772037
  782050
  783386
  823174
]
1.95 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife white"
]
1.90 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен white"
]
1.72 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен white"
]

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.