Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.96 ms
(85.46%)
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
  396623
  469035
  469055
  469994
  477494
  510587
  512214
  530421
  531058
  533596
  534975
  538556
  546155
  547608
  552764
  573321
  575935
  584539
  587546
  593488
  619679
  622624
  623268
  657178
  660409
  670067
  678547
  684251
  705718
  710893
  712235
  714125
  717670
  717942
  719650
  722426
  722455
  723625
  723658
  730932
  731168
  735048
  740820
  743099
  748594
  749118
  749799
  754646
  755137
  756016
  756428
  759872
  762264
  764085
  766276
  769067
  769286
  770812
  771361
  771850
  772391
  779785
  782523
  784918
  786010
  786069
  786285
  787113
  788105
  790028
  791103
  791256
  792146
  795128
  800330
  804111
  804118
  804590
  805813
  807342
  810006
  810272
  813734
  815930
  816215
  816686
  816842
  817107
  817149
  817159
  817185
  817960
  818675
  818715
  819228
  819312
  819765
  819978
  820383
  820660
  821112
  821121
  822313
  822489
  822571
  822572
  822633
  822817
  823003
  823056
  823057
  823082
  824042
  825799
  826032
  826253
  827068
  828390
]
12.67 ms
(7.97%)
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
  730932
  749799
  755137
  787113
  735048
  622624
  584539
  619679
  546155
  817107
  819765
  819978
  817185
  530421
  512214
  552764
  717670
  722455
  784918
  786069
  795128
  810272
  769067
  786010
  786285
  804590
  756016
  764085
  771850
  740820
  779785
  717942
  660409
  821121
  823492
  816215
  469035
  575935
  657178
  714125
  719650
  678547
  593488
  587546
  623268
  792146
  805813
  810006
  791256
  800330
  762264
  782523
  807342
  749118
  756428
  759872
  748594
  768512
  766276
  770812
  790028
  769286
  469055
  684251
  712235
  754646
  396623
  815930
  827068
  469994
  573321
  705718
  670067
  710893
  772391
  788105
  791103
  771361
  731168
  743099
  722426
  804111
  804118
  816686
  816842
  817960
  819228
  820660
  823082
  723625
  723658
  818675
  818715
  822572
  825799
  820383
  821112
  822313
  822489
  822571
  822633
  822817
  823003
  823056
  823057
  826253
  813734
  817149
  817159
  819312
  824042
  828390
  826032
  477494
  510587
  531058
  533596
  538556
  534975
  547608
]
3.26 ms
(2.05%)
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
  396623
  469035
  469055
  469994
  477494
  510587
  512214
  530421
  531058
  533596
  534975
  538556
  546155
  547608
  552764
  573321
  575935
  584539
  587546
  593488
  619679
  622624
  623268
  657178
  660409
  670067
  678547
  684251
  705718
  710893
  712235
  714125
  717670
  717942
  719650
  722426
  722455
  723625
  723658
  730932
  731168
  735048
  740820
  743099
  748594
  749118
  749799
  754646
  755137
  756016
  756428
  759872
  762264
  764085
  766276
  769067
  769286
  770812
  771361
  771850
  772391
  779785
  782523
  784918
  786010
  786069
  786285
  787113
  788105
  790028
  791103
  791256
  792146
  795128
  800330
  804111
  804118
  804590
  805813
  807342
  810006
  810272
  813734
  815930
  816215
  816686
  816842
  817107
  817149
  817159
  817185
  817960
  818675
  818715
  819228
  819312
  819765
  819978
  820383
  820660
  821112
  821121
  822313
  822489
  822571
  822572
  822633
  822817
  823003
  823056
  823057
  823082
  824042
  825799
  826032
  826253
  827068
  828390
]
2.16 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "long sex toys"
]
1.92 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "длинные секс toys"
]
1.64 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "длинные секс toys"
]

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.