Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.00 ms
(78.67%)
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
  96530
  152276
  152508
  359441
  395354
  395398
  395401
  415497
  416146
  417878
  418575
  424839
  437302
  437338
  439899
  444163
  447725
  448262
  450711
  453391
  461115
  461851
  463632
  464211
  465215
  466299
  471591
  472963
  482007
  485095
  485636
  491603
  491643
  495026
  495311
  500044
  506127
  514776
  514858
  515586
  521092
  522493
  526697
  543384
  546128
  547834
  552865
  553553
  557539
  561285
  561447
  562699
  564189
  569241
  569394
  572276
  578785
  579304
  579974
  580533
  585473
  586019
  586050
  587711
  589677
  590214
  590223
  593985
  599490
  602405
  606438
  608428
  609214
  610672
  615673
  615707
  621267
  623983
  625233
  629831
  632734
  641482
  643319
  647302
  650687
  672765
  677143
  689169
  691832
  692750
  693468
  708433
  708517
  713329
  718790
  722227
  724604
  736905
  736965
  750724
  751600
  758793
  760698
  768186
  771251
  772151
  775379
  783267
  783392
  784303
  793368
  798535
  798681
  805497
  807486
  809696
  810521
  813071
  819353
  821838
]
23.40 ms
(14.61%)
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
  557539
  650687
  677143
  689169
  672765
  589677
  590223
  602405
  623983
  643319
  625233
  783267
  810521
  807486
  750724
  629831
  798535
  809696
  152508
  461851
  152276
  395398
  359441
  415497
  444163
  416146
  819353
  821838
  465215
  453391
  482007
  491603
  495311
  500044
  526697
  485095
  569394
  543384
  692750
  722227
  708433
  580533
  586019
  599490
  593985
  641482
  586050
  615673
  590214
  775379
  793368
  798681
  736965
  751600
  724604
  736905
  768186
  771251
  760698
  608428
  610672
  713329
  718790
  813071
  417878
  466299
  418575
  439899
  471591
  447725
  437302
  514776
  485636
  491643
  521092
  515586
  96530
  395354
  395401
  424839
  437338
  448262
  464211
  450711
  461115
  495026
  506127
  514858
  522493
  463632
  472963
  561447
  569241
  572276
  552865
  561285
  564189
  562699
  578785
  579974
  647302
  708517
  691832
  693468
  546128
  547834
  553553
  579304
  615707
  621267
  632734
  606438
  609214
  585473
  587711
  783392
  784303
  805497
  758793
  772151
]
3.13 ms
(1.95%)
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
  96530
  152276
  152508
  359441
  395354
  395398
  395401
  415497
  416146
  417878
  418575
  424839
  437302
  437338
  439899
  444163
  447725
  448262
  450711
  453391
  461115
  461851
  463632
  464211
  465215
  466299
  471591
  472963
  482007
  485095
  485636
  491603
  491643
  495026
  495311
  500044
  506127
  514776
  514858
  515586
  521092
  522493
  526697
  543384
  546128
  547834
  552865
  553553
  557539
  561285
  561447
  562699
  564189
  569241
  569394
  572276
  578785
  579304
  579974
  580533
  585473
  586019
  586050
  587711
  589677
  590214
  590223
  593985
  599490
  602405
  606438
  608428
  609214
  610672
  615673
  615707
  621267
  623983
  625233
  629831
  632734
  641482
  643319
  647302
  650687
  672765
  677143
  689169
  691832
  692750
  693468
  708433
  708517
  713329
  718790
  722227
  724604
  736905
  736965
  750724
  751600
  758793
  760698
  768186
  771251
  772151
  775379
  783267
  783392
  784303
  793368
  798535
  798681
  805497
  807486
  809696
  810521
  813071
  819353
  821838
]
2.06 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "room hotel"
]
1.98 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "room hotel"
]
1.92 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "room hotel"
]

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.