Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.69 ms
(85.78%)
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
  350574
  382138
  411228
  419836
  419843
  426440
  429300
  429508
  444649
  444828
  446091
  446992
  457518
  464253
  469640
  471141
  476503
  476610
  478442
  481812
  485308
  494274
  494734
  497904
  501656
  502488
  503786
  506810
  510557
  512871
  513979
  516988
  517729
  518628
  518887
  519777
  526000
  526475
  529050
  529883
  530358
  532904
  533274
  535562
  536461
  536691
  537927
  538804
  540136
  541576
  543856
  546798
  546800
  546808
  549223
  550176
  550679
  552006
  552070
  552602
  559192
  559208
  559246
  559856
  560904
  562467
  566791
  569720
  569743
  576657
  598325
  602037
  605487
  609901
  610959
  615658
  616000
  623838
  623868
  628517
  632557
  650810
  668012
  668545
  680137
  704180
  714666
  715826
  716629
  716756
  726291
  726292
  728768
  735727
  751503
  755377
  758533
  772964
  782544
  789805
  794809
  796740
  796773
  800628
  801593
  802105
  806674
  810841
  814685
  816994
  817025
  817036
  817174
  817186
  817187
  818318
  819564
  819608
  819613
  824921
]
15.96 ms
(8.26%)
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
  518628
  559856
  628517
  814685
  446992
  543856
  569720
  569743
  715826
  704180
  726291
  550679
  429508
  494274
  559246
  559192
  716629
  801593
  546808
  529050
  540136
  758533
  598325
  559208
  615658
  819564
  526000
  818318
  714666
  609901
  772964
  796740
  519777
  576657
  802105
  610959
  782544
  810841
  806674
  494734
  552070
  789805
  457518
  538804
  716756
  819608
  476610
  616000
  817187
  816994
  533274
  632557
  536691
  751503
  728768
  819613
  623838
  726292
  485308
  526475
  552006
  550176
  549223
  546800
  536461
  471141
  497904
  444828
  562467
  755377
  419836
  796773
  476503
  512871
  518887
  817174
  817025
  546798
  478442
  552602
  623868
  602037
  429300
  419843
  382138
  529883
  535562
  506810
  735727
  411228
  817036
  501656
  469640
  800628
  444649
  532904
  794809
  817186
  530358
  566791
  350574
  446091
  503786
  516988
  513979
  668012
  560904
  426440
  510557
  502488
  537927
  541576
  668545
  650810
  605487
  481812
  464253
  517729
  680137
  824921
]
2.77 ms
(1.44%)
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
  350574
  382138
  411228
  419836
  419843
  426440
  429300
  429508
  444649
  444828
  446091
  446992
  457518
  464253
  469640
  471141
  476503
  476610
  478442
  481812
  485308
  494274
  494734
  497904
  501656
  502488
  503786
  506810
  510557
  512871
  513979
  516988
  517729
  518628
  518887
  519777
  526000
  526475
  529050
  529883
  530358
  532904
  533274
  535562
  536461
  536691
  537927
  538804
  540136
  541576
  543856
  546798
  546800
  546808
  549223
  550176
  550679
  552006
  552070
  552602
  559192
  559208
  559246
  559856
  560904
  562467
  566791
  569720
  569743
  576657
  598325
  602037
  605487
  609901
  610959
  615658
  616000
  623838
  623868
  628517
  632557
  650810
  668012
  668545
  680137
  704180
  714666
  715826
  716629
  716756
  726291
  726292
  728768
  735727
  751503
  755377
  758533
  772964
  782544
  789805
  794809
  796740
  796773
  800628
  801593
  802105
  806674
  810841
  814685
  816994
  817025
  817036
  817174
  817186
  817187
  818318
  819564
  819608
  819613
  824921
]
2.69 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "slave girl bondage"
]
2.28 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.90 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "доминирован девушк бдсм"
]
1.86 ms
(0.96%)
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.