Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.75 ms
(84.09%)
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
  3561
  89480
  124361
  187353
  187735
  188456
  325846
  365880
  381862
  382610
  382690
  383367
  385014
  385088
  386667
  388193
  390918
  395145
  396941
  396971
  397209
  407748
  407767
  408415
  409126
  409276
  409330
  411985
  413283
  419839
  428141
  428907
  451466
  452238
  453092
  453462
  462963
  466318
  466914
  468920
  481915
  506836
  510819
  512046
  514920
  532365
  537111
  537147
  544465
  544479
  546928
  558284
  561047
  561459
  562645
  583306
  587184
  591531
  663423
  665867
  665893
  667266
  667314
  667656
  669023
  670185
  674091
  692805
  693032
  718552
  720007
  720530
  721421
  721466
  721482
  726330
  727935
  732742
  735484
  739620
  739955
  745453
  745844
  747073
  748146
  748213
  748222
  748504
  752703
  754436
  755960
  760211
  762669
  770097
  770237
  772554
  773543
  774326
  777417
  779199
  780720
  781646
  781850
  782287
  796450
  796957
  799020
  802453
  803070
  803106
  807637
  812742
  813685
  814866
  815722
  816085
  817957
  819238
  823613
  823806
]
13.20 ms
(8.55%)
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
  561459
  720530
  558284
  807637
  727935
  770097
  770237
  754436
  803106
  365880
  428141
  388193
  506836
  382610
  411985
  187735
  325846
  386667
  397209
  419839
  772554
  407767
  385088
  383367
  381862
  390918
  409330
  814866
  823806
  532365
  721421
  669023
  674091
  721482
  591531
  777417
  802453
  782287
  747073
  735484
  748222
  773543
  468920
  453092
  537147
  395145
  3561
  396971
  396941
  408415
  813685
  816085
  817957
  823613
  452238
  453462
  512046
  537111
  514920
  583306
  544465
  544479
  562645
  665867
  667656
  665893
  667314
  692805
  693032
  721466
  663423
  667266
  779199
  780720
  781850
  745453
  748146
  774326
  799020
  803070
  726330
  739620
  745844
  732742
  762669
  781646
  409126
  466318
  760211
  89480
  187353
  462963
  385014
  466914
  124361
  413283
  815722
  428907
  510819
  382690
  188456
  819238
  720007
  796957
  748213
  748504
  752703
  739955
  718552
  451466
  481915
  561047
  407748
  409276
  546928
  670185
  587184
  796450
  812742
  755960
]
3.70 ms
(2.39%)
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
  3561
  89480
  124361
  187353
  187735
  188456
  325846
  365880
  381862
  382610
  382690
  383367
  385014
  385088
  386667
  388193
  390918
  395145
  396941
  396971
  397209
  407748
  407767
  408415
  409126
  409276
  409330
  411985
  413283
  419839
  428141
  428907
  451466
  452238
  453092
  453462
  462963
  466318
  466914
  468920
  481915
  506836
  510819
  512046
  514920
  532365
  537111
  537147
  544465
  544479
  546928
  558284
  561047
  561459
  562645
  583306
  587184
  591531
  663423
  665867
  665893
  667266
  667314
  667656
  669023
  670185
  674091
  692805
  693032
  718552
  720007
  720530
  721421
  721466
  721482
  726330
  727935
  732742
  735484
  739620
  739955
  745453
  745844
  747073
  748146
  748213
  748222
  748504
  752703
  754436
  755960
  760211
  762669
  770097
  770237
  772554
  773543
  774326
  777417
  779199
  780720
  781646
  781850
  782287
  796450
  796957
  799020
  802453
  803070
  803106
  807637
  812742
  813685
  814866
  815722
  816085
  817957
  819238
  823613
  823806
]
2.10 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелые в чулка"
]
2.09 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин чулк нижн бел"
]
1.56 ms
(1.01%)
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.