Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.03 ms
(86.98%)
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
  3576
  6694
  32549
  73289
  131517
  145757
  187759
  187974
  188462
  370905
  382284
  382385
  385690
  388776
  394433
  395938
  397889
  398567
  400728
  401303
  405191
  406616
  407531
  407586
  407938
  409016
  409702
  409882
  411630
  411729
  423455
  433685
  446634
  453105
  453157
  456019
  459633
  460003
  461320
  463295
  465597
  466914
  471011
  476306
  477975
  479351
  480481
  483675
  490637
  497859
  499844
  499919
  504028
  519152
  535319
  536986
  544468
  544492
  549240
  552688
  558019
  560409
  562420
  567615
  577419
  577576
  578158
  581345
  599737
  605313
  610038
  621682
  650146
  660807
  665187
  665224
  665372
  665416
  665419
  681179
  700804
  710856
  715420
  718498
  718570
  722155
  723961
  724719
  724748
  725136
  725199
  726262
  728381
  728958
  729058
  731789
  733266
  736138
  740457
  742280
  745997
  748431
  753244
  755414
  758799
  759015
  781771
  794684
  795341
  795918
  796343
  800661
  800737
  802048
  809907
  809993
  810100
  824320
  824587
  827249
]
14.13 ms
(7.88%)
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
  715420
  681179
  794684
  453105
  800661
  544492
  724719
  728958
  740457
  497859
  795918
  188462
  73289
  433685
  577419
  665372
  423455
  827249
  731789
  544468
  461320
  567615
  725199
  745997
  802048
  411729
  476306
  465597
  733266
  409702
  519152
  718498
  718570
  755414
  809907
  499844
  6694
  560409
  456019
  742280
  32549
  409882
  536986
  499919
  535319
  578158
  599737
  759015
  723961
  131517
  407938
  397889
  549240
  665187
  382385
  795341
  605313
  446634
  145757
  471011
  407531
  406616
  187759
  394433
  824587
  650146
  665419
  710856
  729058
  810100
  728381
  700804
  800737
  504028
  552688
  577576
  665416
  665224
  758799
  409016
  479351
  405191
  370905
  187974
  490637
  824320
  483675
  463295
  809993
  796343
  725136
  748431
  781771
  753244
  388776
  621682
  724748
  460003
  562420
  722155
  726262
  3576
  610038
  401303
  459633
  660807
  581345
  395938
  398567
  411630
  736138
  382284
  558019
  453157
  477975
  407586
  400728
  385690
  480481
  466914
]
2.75 ms
(1.53%)
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
  3576
  6694
  32549
  73289
  131517
  145757
  187759
  187974
  188462
  370905
  382284
  382385
  385690
  388776
  394433
  395938
  397889
  398567
  400728
  401303
  405191
  406616
  407531
  407586
  407938
  409016
  409702
  409882
  411630
  411729
  423455
  433685
  446634
  453105
  453157
  456019
  459633
  460003
  461320
  463295
  465597
  466914
  471011
  476306
  477975
  479351
  480481
  483675
  490637
  497859
  499844
  499919
  504028
  519152
  535319
  536986
  544468
  544492
  549240
  552688
  558019
  560409
  562420
  567615
  577419
  577576
  578158
  581345
  599737
  605313
  610038
  621682
  650146
  660807
  665187
  665224
  665372
  665416
  665419
  681179
  700804
  710856
  715420
  718498
  718570
  722155
  723961
  724719
  724748
  725136
  725199
  726262
  728381
  728958
  729058
  731789
  733266
  736138
  740457
  742280
  745997
  748431
  753244
  755414
  758799
  759015
  781771
  794684
  795341
  795918
  796343
  800661
  800737
  802048
  809907
  809993
  810100
  824320
  824587
  827249
]
2.17 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебля волосатых женщин…"
]
1.57 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс волосатая женщин"
]
1.48 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.27 ms
(0.71%)
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.