Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.36 ms
(82.87%)
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
  397901
  404477
  411933
  412332
  415821
  419538
  423361
  427668
  432361
  432426
  437929
  440954
  446070
  447749
  453227
  454536
  455248
  459253
  460929
  461447
  461722
  461837
  466034
  466185
  467099
  468304
  469154
  471743
  474399
  474964
  475815
  478232
  478848
  479846
  480007
  480245
  480705
  480928
  482296
  483795
  484033
  487209
  488364
  490278
  492811
  493319
  493953
  495088
  497103
  497319
  497949
  503418
  503506
  505963
  506667
  507089
  508819
  509317
  509605
  512546
  512737
  515711
  516402
  517975
  519508
  519653
  520888
  521174
  521472
  521968
  521984
  522064
  522744
  522997
  523412
  524552
  524691
  524965
  525652
  525984
  526890
  527163
  527182
  527675
  527852
  533973
  536868
  540553
  542559
  544958
  545692
  549663
  552353
  556534
  560373
  561560
  562804
  562834
  569012
  569784
  570957
  581423
  582235
  582243
  591670
  597477
  599358
  599531
  606299
  612478
  616472
  616972
  617129
  617543
  623528
  626549
  634589
  650537
  655667
  668559
]
15.73 ms
(10.57%)
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
  599358
  617543
  634589
  419538
  447749
  461722
  397901
  404477
  412332
  432426
  461447
  466034
  466185
  478848
  480007
  480705
  411933
  461837
  427668
  437929
  454536
  474399
  474964
  478232
  446070
  455248
  468304
  479846
  509317
  512546
  484033
  490278
  512737
  521984
  524691
  487209
  492811
  497949
  507089
  517975
  527675
  488364
  493319
  493953
  497319
  508819
  515711
  522064
  525984
  533973
  655667
  650537
  467099
  525652
  668559
  475815
  505963
  521472
  483795
  549663
  570957
  523412
  599531
  480928
  459253
  480245
  460929
  471743
  521174
  503506
  519508
  527852
  503418
  506667
  540553
  544958
  569012
  582235
  562804
  552353
  562834
  556534
  561560
  582243
  597477
  606299
  612478
  617129
  623528
  591670
  616472
  626549
  423361
  509605
  521968
  522744
  524552
  520888
  495088
  527182
  581423
  432361
  440954
  415821
  616972
  482296
  469154
  453227
  522997
  527163
  536868
  516402
  519653
  524965
  526890
  497103
  542559
  560373
  545692
  569784
]
2.51 ms
(1.69%)
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
  397901
  404477
  411933
  412332
  415821
  419538
  423361
  427668
  432361
  432426
  437929
  440954
  446070
  447749
  453227
  454536
  455248
  459253
  460929
  461447
  461722
  461837
  466034
  466185
  467099
  468304
  469154
  471743
  474399
  474964
  475815
  478232
  478848
  479846
  480007
  480245
  480705
  480928
  482296
  483795
  484033
  487209
  488364
  490278
  492811
  493319
  493953
  495088
  497103
  497319
  497949
  503418
  503506
  505963
  506667
  507089
  508819
  509317
  509605
  512546
  512737
  515711
  516402
  517975
  519508
  519653
  520888
  521174
  521472
  521968
  521984
  522064
  522744
  522997
  523412
  524552
  524691
  524965
  525652
  525984
  526890
  527163
  527182
  527675
  527852
  533973
  536868
  540553
  542559
  544958
  545692
  549663
  552353
  556534
  560373
  561560
  562804
  562834
  569012
  569784
  570957
  581423
  582235
  582243
  591670
  597477
  599358
  599531
  606299
  612478
  616472
  616972
  617129
  617543
  623528
  626549
  634589
  650537
  655667
  668559
]
2.08 ms
(1.40%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в юбк"
]
2.03 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончил в юбке"
]
1.59 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм в юбк"
]
1.55 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.