Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.12 ms
(81.42%)
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
  146800
  154157
  188560
  381812
  382158
  387026
  391917
  391926
  392848
  394639
  398376
  403896
  414099
  414595
  416583
  416686
  416707
  424613
  428171
  441120
  448791
  448880
  452914
  471122
  473446
  473448
  473453
  477760
  493700
  493838
  497471
  506115
  511862
  512072
  513830
  515419
  518905
  530402
  530451
  530688
  531822
  531856
  531877
  532634
  545438
  545459
  547475
  547486
  548153
  550917
  554851
  561019
  564255
  564518
  571726
  574377
  574656
  575589
  576533
  577284
  583472
  587292
  588223
  590831
  623275
  625780
  629711
  629732
  634027
  634108
  639315
  642013
  656879
  656888
  660369
  660394
  660412
  660415
  660417
  666855
  669017
  669056
  669357
  670366
  671038
  671043
  672952
  686183
  705360
  705459
  705479
  711611
  713503
  717514
  717520
  717542
  718701
  720101
  720448
  729327
  740926
  745083
  745113
  745114
  749207
  749603
  751294
  752686
  752705
  752755
  760513
  763739
  781326
  788529
  791328
  796939
  800528
  803633
  805046
  822975
]
16.65 ms
(11.10%)
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
  634027
  623275
  800528
  788529
  745114
  751294
  416583
  497471
  666855
  720101
  550917
  188560
  392848
  414099
  531877
  532634
  511862
  506115
  530402
  547475
  574377
  583472
  545459
  561019
  564518
  660417
  669357
  660369
  672952
  660415
  671038
  718701
  796939
  428171
  493838
  763739
  515419
  414595
  387026
  670366
  513830
  577284
  740926
  398376
  416707
  448880
  512072
  781326
  642013
  660394
  381812
  416686
  154157
  403896
  473453
  518905
  493700
  452914
  391917
  424613
  634108
  477760
  587292
  473448
  471122
  382158
  705459
  705479
  805046
  146800
  530451
  530688
  564255
  711611
  713503
  656879
  656888
  686183
  720448
  639315
  629732
  629711
  590831
  803633
  749207
  729327
  749603
  760513
  531822
  531856
  574656
  576533
  717542
  717520
  752686
  752755
  745083
  705360
  441120
  448791
  394639
  547486
  554851
  575589
  548153
  671043
  660412
  669056
  669017
  717514
  391926
  822975
  588223
  791328
  745113
  752705
  571726
  625780
  473446
  545438
]
3.49 ms
(2.33%)
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
  146800
  154157
  188560
  381812
  382158
  387026
  391917
  391926
  392848
  394639
  398376
  403896
  414099
  414595
  416583
  416686
  416707
  424613
  428171
  441120
  448791
  448880
  452914
  471122
  473446
  473448
  473453
  477760
  493700
  493838
  497471
  506115
  511862
  512072
  513830
  515419
  518905
  530402
  530451
  530688
  531822
  531856
  531877
  532634
  545438
  545459
  547475
  547486
  548153
  550917
  554851
  561019
  564255
  564518
  571726
  574377
  574656
  575589
  576533
  577284
  583472
  587292
  588223
  590831
  623275
  625780
  629711
  629732
  634027
  634108
  639315
  642013
  656879
  656888
  660369
  660394
  660412
  660415
  660417
  666855
  669017
  669056
  669357
  670366
  671038
  671043
  672952
  686183
  705360
  705459
  705479
  711611
  713503
  717514
  717520
  717542
  718701
  720101
  720448
  729327
  740926
  745083
  745113
  745114
  749207
  749603
  751294
  752686
  752705
  752755
  760513
  763739
  781326
  788529
  791328
  796939
  800528
  803633
  805046
  822975
]
2.19 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал мастурбация дилдо"
]
1.95 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал мастурбац дилд"
]
1.92 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал мастурбац дилд"
]
1.67 ms
(1.11%)
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.