Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.54 ms
(82.99%)
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
  205
  38135
  117844
  117905
  373406
  386938
  389832
  390389
  390587
  392100
  397567
  398074
  398287
  398300
  398869
  400707
  401793
  402239
  415921
  418201
  418933
  428956
  429362
  430520
  432703
  432982
  434382
  436836
  439268
  440780
  443784
  444431
  444794
  445099
  446063
  446785
  452262
  452880
  453002
  454133
  454579
  454655
  460280
  461704
  464019
  464023
  466308
  467010
  467110
  469455
  469592
  469845
  471703
  473428
  473439
  479708
  479713
  485246
  486635
  486845
  493813
  495501
  495573
  496126
  498541
  499252
  503473
  509995
  510542
  514854
  520797
  526167
  529621
  530436
  536121
  542989
  545616
  551494
  559290
  576439
  576607
  580397
  589243
  591043
  591420
  615692
  632927
  635701
  650663
  657565
  658785
  663306
  670411
  687315
  693973
  724285
  733454
  738499
  742727
  749172
  754351
  754399
  754770
  754800
  757669
  759755
  766317
  772548
  774878
  778246
  783882
  785748
  786723
  788577
  792184
  797856
  803401
  805990
  811234
  812598
]
20.14 ms
(11.40%)
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
  401793
  551494
  510542
  811234
  418201
  803401
  400707
  693973
  754770
  754800
  446785
  397567
  205
  485246
  469455
  454579
  398300
  446063
  559290
  461704
  434382
  498541
  663306
  432703
  436836
  576439
  635701
  38135
  530436
  589243
  415921
  576607
  398074
  657565
  733454
  805990
  724285
  390389
  754399
  402239
  398869
  418933
  444794
  520797
  545616
  469845
  792184
  486845
  440780
  467110
  473428
  687315
  591043
  785748
  766317
  591420
  495573
  467010
  117844
  389832
  398287
  428956
  788577
  754351
  473439
  529621
  454655
  464019
  479713
  742727
  390587
  632927
  499252
  514854
  445099
  453002
  386938
  496126
  493813
  443784
  460280
  466308
  542989
  444431
  670411
  797856
  479708
  615692
  464023
  503473
  509995
  430520
  439268
  452880
  454133
  526167
  392100
  471703
  778246
  774878
  812598
  432982
  429362
  373406
  495501
  452262
  580397
  650663
  772548
  738499
  759755
  783882
  117905
  486635
  469592
  536121
  658785
  749172
  786723
  757669
]
2.91 ms
(1.65%)
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
  205
  38135
  117844
  117905
  373406
  386938
  389832
  390389
  390587
  392100
  397567
  398074
  398287
  398300
  398869
  400707
  401793
  402239
  415921
  418201
  418933
  428956
  429362
  430520
  432703
  432982
  434382
  436836
  439268
  440780
  443784
  444431
  444794
  445099
  446063
  446785
  452262
  452880
  453002
  454133
  454579
  454655
  460280
  461704
  464019
  464023
  466308
  467010
  467110
  469455
  469592
  469845
  471703
  473428
  473439
  479708
  479713
  485246
  486635
  486845
  493813
  495501
  495573
  496126
  498541
  499252
  503473
  509995
  510542
  514854
  520797
  526167
  529621
  530436
  536121
  542989
  545616
  551494
  559290
  576439
  576607
  580397
  589243
  591043
  591420
  615692
  632927
  635701
  650663
  657565
  658785
  663306
  670411
  687315
  693973
  724285
  733454
  738499
  742727
  749172
  754351
  754399
  754770
  754800
  757669
  759755
  766317
  772548
  774878
  778246
  783882
  785748
  786723
  788577
  792184
  797856
  803401
  805990
  811234
  812598
]
2.03 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "попа секс игрушки"
]
1.82 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп секс игрушк"
]
1.39 ms
(0.79%)
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.