Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
337.99 ms
(93.01%)
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
  466387
  517539
  520879
  542726
  548389
  551578
  554841
  554843
  558889
  560493
  562111
  565445
  579866
  580025
  581392
  581550
  585350
  585927
  586559
  588391
  591503
  599987
  604636
  605060
  607503
  613768
  613958
  614330
  614743
  629680
  630821
  633716
  634883
  639060
  639125
  640361
  655568
  655569
  660053
  664602
  667471
  668330
  674202
  678796
  685511
  699179
  706524
  707236
  710026
  719829
  724039
  725194
  725470
  725474
  725487
  726802
  726878
  728616
  731022
  732858
  732923
  733085
  733122
  735828
  737598
  738118
  738326
  738445
  738675
  738694
  741761
  744167
  744765
  745998
  751384
  751390
  752477
  756461
  757217
  757237
  758145
  758251
  759313
  760939
  765812
  766450
  768681
  771272
  778692
  781358
  783308
  783920
  783930
  784246
  785114
  790082
  790104
  795924
  795974
  796635
  797255
  800726
  801788
  801810
  802194
  804416
  804428
  804437
  809358
  809851
  811852
  811887
  811896
  811902
  811905
  811907
  817207
  824000
  824196
  827190
]
14.56 ms
(4.01%)
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
  586559
  585927
  588391
  613958
  614330
  784246
  785114
  778692
  800726
  802194
  725474
  744167
  765812
  790104
  735828
  756461
  768681
  744765
  758251
  771272
  726802
  728616
  751390
  783930
  795974
  796635
  804428
  737598
  781358
  614743
  725470
  757237
  733122
  824196
  827190
  824000
  517539
  520879
  548389
  562111
  542726
  554841
  579866
  581550
  664602
  660053
  707236
  719829
  685511
  554843
  565445
  581392
  591503
  607503
  613768
  630821
  634883
  585350
  801788
  809358
  809851
  811902
  811905
  804416
  738118
  757217
  783308
  783920
  795924
  797255
  811852
  725194
  731022
  741761
  751384
  738326
  738445
  760939
  752477
  766450
  738694
  745998
  758145
  633716
  801810
  804437
  811896
  466387
  759313
  599987
  639060
  732858
  733085
  817207
  558889
  560493
  580025
  667471
  674202
  655569
  668330
  706524
  655568
  678796
  699179
  710026
  551578
  604636
  639125
  640361
  605060
  629680
  790082
  811887
  811907
  725487
  724039
  726878
  732923
  738675
]
3.42 ms
(0.94%)
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
  466387
  517539
  520879
  542726
  548389
  551578
  554841
  554843
  558889
  560493
  562111
  565445
  579866
  580025
  581392
  581550
  585350
  585927
  586559
  588391
  591503
  599987
  604636
  605060
  607503
  613768
  613958
  614330
  614743
  629680
  630821
  633716
  634883
  639060
  639125
  640361
  655568
  655569
  660053
  664602
  667471
  668330
  674202
  678796
  685511
  699179
  706524
  707236
  710026
  719829
  724039
  725194
  725470
  725474
  725487
  726802
  726878
  728616
  731022
  732858
  732923
  733085
  733122
  735828
  737598
  738118
  738326
  738445
  738675
  738694
  741761
  744167
  744765
  745998
  751384
  751390
  752477
  756461
  757217
  757237
  758145
  758251
  759313
  760939
  765812
  766450
  768681
  771272
  778692
  781358
  783308
  783920
  783930
  784246
  785114
  790082
  790104
  795924
  795974
  796635
  797255
  800726
  801788
  801810
  802194
  804416
  804428
  804437
  809358
  809851
  811852
  811887
  811896
  811902
  811905
  811907
  817207
  824000
  824196
  827190
]
2.00 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "piss wife"
]
1.98 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "писсинг жен"
]
1.86 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.44%)
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.