Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.47 ms
(53.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "лижут жопу парню"
]
151.94 ms
(39.93%)
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
  95586
  146721
  229460
  261599
  263335
  359968
  373406
  383418
  386070
  396961
  397431
  398695
  400128
  400992
  401468
  404311
  404503
  407504
  407570
  407761
  407771
  411365
  411654
  411967
  413457
  413968
  415735
  416859
  416926
  419059
  419565
  421198
  421780
  424564
  426808
  428531
  428775
  429042
  429531
  430084
  430468
  430822
  432317
  434661
  438226
  443996
  444588
  444926
  445842
  447303
  447530
  447551
  448704
  451310
  452624
  453746
  454721
  455083
  463258
  464982
  465209
  466693
  467342
  468945
  469489
  469493
  471183
  474302
  475847
  477116
  478474
  480365
  482237
  482404
  487479
  519039
  532597
  534376
  546687
  548651
  548736
  552260
  554467
  560520
  561710
  562818
  563189
  566409
  566957
  573501
  576298
  587865
  591628
  599144
  599712
  603606
  606824
  673992
  712311
  712650
  716072
  724719
  736634
  745771
  756318
  761851
  767202
  770437
  779578
  787106
  787302
  788212
  789510
  790997
  794812
  796541
  801173
  807479
  810062
  810292
]
16.39 ms
(4.31%)
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
  767202
  794812
  724719
  736634
  745771
  756318
  770437
  761851
  712650
  779578
  787106
  787302
  789510
  790997
  796541
  810062
  146721
  359968
  407504
  261599
  599144
  534376
  573501
  560520
  519039
  428531
  469489
  471183
  444588
  532597
  386070
  95586
  383418
  229460
  396961
  400128
  413457
  416926
  419059
  421198
  428775
  429531
  430468
  432317
  434661
  438226
  407761
  413968
  407570
  415735
  416859
  424564
  430084
  411967
  411654
  419565
  421780
  482404
  454721
  465209
  466693
  474302
  475847
  477116
  448704
  467342
  445842
  451310
  455083
  469493
  478474
  482237
  487479
  566957
  552260
  554467
  562818
  566409
  673992
  712311
  546687
  548651
  548736
  561710
  563189
  576298
  591628
  587865
  599712
  603606
  788212
  801173
  810292
  606824
  716072
  807479
  373406
  407771
  453746
  263335
  401468
  404311
  404503
  426808
  463258
  468945
  397431
  430822
  443996
  464982
  398695
  400992
  411365
  429042
  444926
  447530
  452624
  480365
  447303
  447551
]
3.27 ms
(0.86%)
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
  95586
  146721
  229460
  261599
  263335
  359968
  373406
  383418
  386070
  396961
  397431
  398695
  400128
  400992
  401468
  404311
  404503
  407504
  407570
  407761
  407771
  411365
  411654
  411967
  413457
  413968
  415735
  416859
  416926
  419059
  419565
  421198
  421780
  424564
  426808
  428531
  428775
  429042
  429531
  430084
  430468
  430822
  432317
  434661
  438226
  443996
  444588
  444926
  445842
  447303
  447530
  447551
  448704
  451310
  452624
  453746
  454721
  455083
  463258
  464982
  465209
  466693
  467342
  468945
  469489
  469493
  471183
  474302
  475847
  477116
  478474
  480365
  482237
  482404
  487479
  519039
  532597
  534376
  546687
  548651
  548736
  552260
  554467
  560520
  561710
  562818
  563189
  566409
  566957
  573501
  576298
  587865
  591628
  599144
  599712
  603606
  606824
  673992
  712311
  712650
  716072
  724719
  736634
  745771
  756318
  761851
  767202
  770437
  779578
  787106
  787302
  788212
  789510
  790997
  794812
  796541
  801173
  807479
  810062
  810292
]
1.61 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анилингус парен"
]
1.51 ms
(0.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.35%)
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.