Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.24 ms
(80.39%)
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
  33459
  391247
  396330
  401924
  403641
  408460
  413074
  414342
  414350
  416292
  419152
  423654
  425961
  427363
  429766
  430704
  443973
  445379
  457290
  457784
  457791
  460361
  461924
  462691
  466367
  466971
  473242
  474013
  474058
  478572
  483371
  486878
  488555
  489998
  493235
  494430
  497533
  501239
  504139
  504141
  506794
  510160
  511021
  514704
  516683
  517859
  522133
  522187
  522900
  523301
  523312
  524766
  526224
  526875
  527070
  527200
  531304
  532665
  533339
  536580
  537929
  545718
  548754
  550587
  551246
  554468
  556051
  557953
  557976
  557983
  558425
  559133
  560198
  561132
  562843
  566439
  566694
  569083
  577374
  580255
  580258
  581692
  582630
  591324
  592456
  593544
  595944
  598099
  599934
  603210
  603217
  603264
  607071
  610304
  617412
  619468
  621318
  633175
  637025
  637438
  644915
  645238
  645241
  646447
  646451
  649106
  649498
  661253
  663448
  663860
  666530
  677952
  680216
  681302
  706945
  712880
  720938
  733867
  748961
  820779
]
20.85 ms
(13.71%)
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
  633175
  527070
  403641
  425961
  457290
  510160
  533339
  526224
  581692
  681302
  645241
  663860
  603210
  621318
  461924
  445379
  523301
  416292
  429766
  514704
  566694
  562843
  569083
  649498
  677952
  548754
  580255
  595944
  637025
  396330
  466367
  460361
  516683
  494430
  483371
  401924
  430704
  478572
  457791
  523312
  531304
  582630
  545718
  557976
  666530
  551246
  577374
  637438
  603217
  610304
  593544
  733867
  748961
  617412
  720938
  466971
  474013
  473242
  423654
  443973
  511021
  526875
  497533
  413074
  489998
  522900
  522187
  501239
  486878
  559133
  560198
  557953
  557983
  580258
  661253
  663448
  706945
  599934
  607071
  603264
  619468
  591324
  474058
  391247
  504139
  506794
  517859
  414342
  561132
  554468
  646447
  419152
  457784
  712880
  536580
  556051
  680216
  566439
  408460
  488555
  645238
  649106
  598099
  33459
  427363
  524766
  646451
  493235
  414350
  644915
  820779
  537929
  522133
  527200
  532665
  558425
  550587
  592456
  462691
  504141
]
2.37 ms
(1.56%)
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
  33459
  391247
  396330
  401924
  403641
  408460
  413074
  414342
  414350
  416292
  419152
  423654
  425961
  427363
  429766
  430704
  443973
  445379
  457290
  457784
  457791
  460361
  461924
  462691
  466367
  466971
  473242
  474013
  474058
  478572
  483371
  486878
  488555
  489998
  493235
  494430
  497533
  501239
  504139
  504141
  506794
  510160
  511021
  514704
  516683
  517859
  522133
  522187
  522900
  523301
  523312
  524766
  526224
  526875
  527070
  527200
  531304
  532665
  533339
  536580
  537929
  545718
  548754
  550587
  551246
  554468
  556051
  557953
  557976
  557983
  558425
  559133
  560198
  561132
  562843
  566439
  566694
  569083
  577374
  580255
  580258
  581692
  582630
  591324
  592456
  593544
  595944
  598099
  599934
  603210
  603217
  603264
  607071
  610304
  617412
  619468
  621318
  633175
  637025
  637438
  644915
  645238
  645241
  646447
  646451
  649106
  649498
  661253
  663448
  663860
  666530
  677952
  680216
  681302
  706945
  712880
  720938
  733867
  748961
  820779
]
1.93 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "orgy fuck"
]
1.65 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "orgy секс"
]
1.55 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "orgy секс"
]
1.46 ms
(0.96%)
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.