Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
254.82 ms
(91.19%)
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
  90485
  167923
  266330
  385037
  385535
  395737
  395876
  395975
  397861
  400042
  400852
  400858
  402266
  411908
  411916
  416303
  420038
  422661
  422978
  422996
  423027
  423080
  427435
  428657
  430287
  434182
  439594
  439669
  441611
  444542
  455354
  465823
  472426
  474109
  474830
  475166
  493951
  498119
  508189
  523396
  526503
  534025
  537587
  550024
  550623
  555864
  556646
  559184
  563481
  564201
  565367
  565665
  566993
  579359
  580702
  584062
  585020
  586256
  586624
  591224
  598731
  600503
  609133
  610021
  610119
  613177
  617722
  619417
  623394
  624290
  630193
  639889
  647333
  665296
  666149
  667316
  667632
  680186
  681879
  694422
  711639
  713122
  716392
  716396
  716450
  717630
  722781
  724766
  727620
  731000
  731884
  732001
  732312
  736042
  741476
  746876
  753486
  769209
  770824
  775284
  775828
  776468
  776845
  777551
  784500
  785337
  786715
  788134
  789527
  790471
  798589
  799768
  801856
  802431
  804532
  806009
  807493
  807692
  820715
  823160
]
15.00 ms
(5.37%)
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
  716450
  666149
  667316
  694422
  716392
  681879
  586624
  610021
  619417
  776468
  786715
  788134
  727620
  746876
  799768
  807692
  741476
  716396
  775284
  775828
  798589
  807493
  266330
  90485
  385037
  823160
  820715
  537587
  713122
  667632
  623394
  801856
  802431
  769209
  167923
  434182
  600503
  444542
  493951
  422996
  498119
  411916
  711639
  777551
  508189
  565367
  427435
  624290
  609133
  610119
  397861
  591224
  420038
  441611
  416303
  439669
  731000
  400042
  411908
  680186
  430287
  639889
  784500
  550623
  665296
  428657
  559184
  579359
  565665
  630193
  385535
  422661
  400852
  555864
  564201
  475166
  790471
  789527
  523396
  566993
  422978
  455354
  400858
  550024
  563481
  717630
  586256
  776845
  804532
  724766
  647333
  613177
  731884
  402266
  580702
  526503
  617722
  770824
  465823
  395975
  598731
  423027
  474830
  474109
  556646
  439594
  395737
  585020
  534025
  753486
  785337
  736042
  732001
  732312
  722781
  395876
  423080
  472426
  806009
  584062
]
2.55 ms
(0.91%)
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
  90485
  167923
  266330
  385037
  385535
  395737
  395876
  395975
  397861
  400042
  400852
  400858
  402266
  411908
  411916
  416303
  420038
  422661
  422978
  422996
  423027
  423080
  427435
  428657
  430287
  434182
  439594
  439669
  441611
  444542
  455354
  465823
  472426
  474109
  474830
  475166
  493951
  498119
  508189
  523396
  526503
  534025
  537587
  550024
  550623
  555864
  556646
  559184
  563481
  564201
  565367
  565665
  566993
  579359
  580702
  584062
  585020
  586256
  586624
  591224
  598731
  600503
  609133
  610021
  610119
  613177
  617722
  619417
  623394
  624290
  630193
  639889
  647333
  665296
  666149
  667316
  667632
  680186
  681879
  694422
  711639
  713122
  716392
  716396
  716450
  717630
  722781
  724766
  727620
  731000
  731884
  732001
  732312
  736042
  741476
  746876
  753486
  769209
  770824
  775284
  775828
  776468
  776845
  777551
  784500
  785337
  786715
  788134
  789527
  790471
  798589
  799768
  801856
  802431
  804532
  806009
  807493
  807692
  820715
  823160
]
1.97 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young девушк чулк нижн бел"
]
1.91 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young girl stockings"
]
1.44 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young девушк чулк нижн бел"
]

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.