Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.39 ms
(88.23%)
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
  370332
  391590
  392216
  394006
  395278
  397294
  397295
  397641
  397762
  398195
  400382
  400713
  401764
  402473
  402859
  403166
  404113
  417821
  427246
  428574
  433751
  441479
  441530
  452907
  499243
  506526
  518905
  520764
  534331
  537245
  540844
  542042
  545717
  546057
  549069
  556166
  568266
  575560
  575583
  575606
  590806
  593560
  594183
  594267
  594430
  595447
  598135
  600945
  602014
  606365
  610688
  612718
  620554
  620805
  620904
  620978
  633870
  636049
  639552
  639959
  645202
  653343
  656593
  657143
  658837
  660338
  660342
  660444
  660597
  660713
  662159
  662204
  669288
  671529
  680230
  683092
  683143
  684887
  687204
  691217
  696107
  696111
  700681
  709037
  712174
  717235
  717812
  720028
  720159
  720362
  725549
  726164
  728745
  728755
  736959
  744907
  748407
  752595
  756687
  761778
  762972
  763493
  767043
  769075
  770295
  774650
  776289
  777652
  778962
  782842
  785582
  787172
  787505
  788550
  791782
  795684
  805654
  814019
  824352
  825018
]
10.70 ms
(6.41%)
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
  656593
  660338
  680230
  683092
  691217
  636049
  594183
  620805
  633870
  598135
  639552
  397641
  398195
  402473
  824352
  556166
  778962
  788550
  748407
  728745
  728755
  720028
  400382
  506526
  394006
  594430
  657143
  575606
  370332
  427246
  520764
  549069
  653343
  645202
  662204
  669288
  696107
  696111
  709037
  660342
  610688
  620554
  620904
  594267
  712174
  534331
  662159
  717812
  782842
  769075
  787172
  791782
  441530
  395278
  545717
  397295
  452907
  397294
  397762
  540844
  546057
  671529
  720362
  658837
  660597
  700681
  717235
  590806
  752595
  787505
  726164
  761778
  762972
  767043
  725549
  756687
  736959
  777652
  639959
  568266
  402859
  499243
  575560
  595447
  602014
  620978
  404113
  401764
  575583
  542042
  403166
  660713
  660444
  683143
  684887
  687204
  606365
  593560
  600945
  612718
  392216
  417821
  428574
  441479
  776289
  774650
  785582
  795684
  805654
  744907
  763493
  770295
  720159
  433751
  391590
  400713
  814019
  825018
  518905
  537245
]
2.38 ms
(1.42%)
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
  370332
  391590
  392216
  394006
  395278
  397294
  397295
  397641
  397762
  398195
  400382
  400713
  401764
  402473
  402859
  403166
  404113
  417821
  427246
  428574
  433751
  441479
  441530
  452907
  499243
  506526
  518905
  520764
  534331
  537245
  540844
  542042
  545717
  546057
  549069
  556166
  568266
  575560
  575583
  575606
  590806
  593560
  594183
  594267
  594430
  595447
  598135
  600945
  602014
  606365
  610688
  612718
  620554
  620805
  620904
  620978
  633870
  636049
  639552
  639959
  645202
  653343
  656593
  657143
  658837
  660338
  660342
  660444
  660597
  660713
  662159
  662204
  669288
  671529
  680230
  683092
  683143
  684887
  687204
  691217
  696107
  696111
  700681
  709037
  712174
  717235
  717812
  720028
  720159
  720362
  725549
  726164
  728745
  728755
  736959
  744907
  748407
  752595
  756687
  761778
  762972
  763493
  767043
  769075
  770295
  774650
  776289
  777652
  778962
  782842
  785582
  787172
  787505
  788550
  791782
  795684
  805654
  814019
  824352
  825018
]
1.88 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen home made"
]
1.75 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen домашн любительск"
]
1.27 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen домашн любительск"
]

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.