Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.32 ms
(85.82%)
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
  76645
  188369
  388350
  391652
  395427
  404175
  404386
  404568
  406561
  408509
  409506
  411334
  411704
  411929
  413904
  415773
  415779
  421654
  422338
  428823
  433769
  439441
  439484
  439766
  440399
  440944
  447969
  448818
  448820
  450154
  450226
  450765
  453265
  454223
  454240
  455058
  456200
  457852
  458728
  460273
  460583
  463156
  464267
  464372
  465535
  466011
  466211
  466875
  466877
  466883
  468123
  468369
  469347
  469505
  469575
  470019
  470043
  470373
  472656
  474674
  474685
  475828
  475904
  476487
  476907
  477521
  481673
  483375
  484681
  485275
  486549
  487706
  489947
  489989
  490484
  491950
  492992
  495813
  499329
  507033
  508603
  511071
  511348
  513480
  515511
  519146
  520881
  520936
  522364
  523401
  523777
  526049
  533198
  536406
  544617
  546964
  555054
  555108
  555126
  555391
  555435
  557244
  564176
  565649
  565887
  579876
  580319
  583730
  590929
  606776
  615525
  618776
  620223
  631504
  707318
  725587
  761018
  765555
  787287
  800511
]
13.63 ms
(8.46%)
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
  511348
  580319
  448818
  468369
  481673
  523777
  519146
  765555
  477521
  555391
  450765
  447969
  606776
  555435
  469505
  453265
  450154
  460273
  476487
  415773
  565887
  448820
  536406
  590929
  564176
  464267
  475904
  508603
  413904
  469347
  415779
  486549
  466011
  495813
  522364
  469575
  557244
  546964
  474674
  485275
  544617
  458728
  579876
  404175
  555108
  422338
  620223
  618776
  460583
  520881
  523401
  499329
  428823
  492992
  472656
  555054
  725587
  555126
  513480
  484681
  421654
  515511
  565649
  463156
  406561
  631504
  615525
  409506
  440944
  533198
  583730
  707318
  787287
  761018
  411929
  439766
  457852
  76645
  455058
  466211
  490484
  440399
  466883
  188369
  391652
  411334
  411704
  464372
  408509
  439441
  489989
  468123
  465535
  388350
  439484
  507033
  483375
  404568
  470019
  466875
  489947
  454240
  800511
  395427
  475828
  511071
  491950
  526049
  520936
  433769
  476907
  470373
  466877
  474685
  450226
  470043
  454223
  487706
  456200
  404386
]
2.49 ms
(1.54%)
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
  76645
  188369
  388350
  391652
  395427
  404175
  404386
  404568
  406561
  408509
  409506
  411334
  411704
  411929
  413904
  415773
  415779
  421654
  422338
  428823
  433769
  439441
  439484
  439766
  440399
  440944
  447969
  448818
  448820
  450154
  450226
  450765
  453265
  454223
  454240
  455058
  456200
  457852
  458728
  460273
  460583
  463156
  464267
  464372
  465535
  466011
  466211
  466875
  466877
  466883
  468123
  468369
  469347
  469505
  469575
  470019
  470043
  470373
  472656
  474674
  474685
  475828
  475904
  476487
  476907
  477521
  481673
  483375
  484681
  485275
  486549
  487706
  489947
  489989
  490484
  491950
  492992
  495813
  499329
  507033
  508603
  511071
  511348
  513480
  515511
  519146
  520881
  520936
  522364
  523401
  523777
  526049
  533198
  536406
  544617
  546964
  555054
  555108
  555126
  555391
  555435
  557244
  564176
  565649
  565887
  579876
  580319
  583730
  590929
  606776
  615525
  618776
  620223
  631504
  707318
  725587
  761018
  765555
  787287
  800511
]
1.94 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончают в пизду зрелкам"
]
1.75 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в вагин зрелая женщин"
]
1.43 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.