Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.26 ms
(84.63%)
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
  7051
  125762
  391310
  396640
  397263
  397296
  397852
  421590
  441485
  442136
  443884
  467948
  478078
  483559
  487363
  501035
  525591
  529131
  531647
  533333
  539276
  539559
  547417
  548254
  549020
  549075
  559996
  560289
  560939
  564223
  564555
  572181
  575846
  578207
  590807
  591082
  592399
  604287
  612363
  616743
  625771
  628484
  631525
  633323
  634511
  637224
  646002
  651873
  654346
  654918
  680251
  697545
  698012
  699899
  702636
  706572
  710736
  712141
  714081
  717213
  720080
  720192
  722583
  729079
  730415
  734326
  734964
  735776
  742742
  743083
  745069
  747498
  750129
  751496
  756160
  757535
  760888
  761679
  767090
  769038
  769070
  769851
  771318
  771923
  775532
  776040
  776960
  777029
  777207
  778951
  778992
  779010
  779241
  779730
  779741
  781331
  781355
  782544
  782619
  783075
  783178
  783180
  787887
  788786
  789871
  790637
  791215
  791246
  791594
  792183
  795523
  795710
  795836
  796916
  797063
  800523
  800554
  809757
  810329
]
16.36 ms
(9.27%)
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
  637224
  779241
  779730
  790637
  760888
  782544
  783180
  743083
  761679
  771923
  729079
  771318
  712141
  776040
  777029
  783075
  788786
  559996
  791215
  769851
  591082
  539559
  483559
  560939
  628484
  717213
  634511
  795710
  751496
  810329
  397852
  631525
  578207
  501035
  564223
  625771
  654918
  796916
  791246
  734964
  734326
  742742
  757535
  397263
  533333
  769740
  391310
  698012
  443884
  800554
  397296
  777207
  750129
  809757
  125762
  779741
  783178
  797063
  646002
  612363
  421590
  720080
  548254
  539276
  699899
  654346
  604287
  747498
  767090
  702636
  787887
  789871
  467948
  531647
  775532
  7051
  547417
  549020
  714081
  706572
  781355
  795523
  735776
  745069
  633323
  487363
  396640
  525591
  529131
  564555
  791594
  778951
  756160
  769038
  781331
  441485
  575846
  572181
  590807
  592399
  730415
  478078
  651873
  722583
  779010
  795836
  800523
  769070
  792183
  710736
  776960
  778992
  560289
  680251
  442136
  549075
  720192
  616743
  782619
  697545
]
3.70 ms
(2.10%)
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
  7051
  125762
  391310
  396640
  397263
  397296
  397852
  421590
  441485
  442136
  443884
  467948
  478078
  483559
  487363
  501035
  525591
  529131
  531647
  533333
  539276
  539559
  547417
  548254
  549020
  549075
  559996
  560289
  560939
  564223
  564555
  572181
  575846
  578207
  590807
  591082
  592399
  604287
  612363
  616743
  625771
  628484
  631525
  633323
  634511
  637224
  646002
  651873
  654346
  654918
  680251
  697545
  698012
  699899
  702636
  706572
  710736
  712141
  714081
  717213
  720080
  720192
  722583
  729079
  730415
  734326
  734964
  735776
  742742
  743083
  745069
  747498
  750129
  751496
  756160
  757535
  760888
  761679
  767090
  769038
  769070
  769851
  771318
  771923
  775532
  776040
  776960
  777029
  777207
  778951
  778992
  779010
  779241
  779730
  779741
  781331
  781355
  782544
  782619
  783075
  783178
  783180
  787887
  788786
  789871
  790637
  791215
  791246
  791594
  792183
  795523
  795710
  795836
  796916
  797063
  800523
  800554
  809757
  810329
]
2.16 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончил девушку в попу%…"
]
1.68 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм девушк анал"
]
1.67 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.87%)
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.