Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.92 ms
(86.85%)
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
  25650
  45799
  61313
  102334
  111260
  116623
  153249
  187418
  191117
  213598
  269287
  352187
  382321
  382671
  383109
  385855
  388284
  388726
  391956
  396043
  396349
  397633
  428064
  446900
  455530
  466902
  483642
  487753
  493195
  496324
  506274
  511083
  519344
  522503
  530122
  531801
  531858
  533317
  534624
  535744
  539660
  543135
  543152
  543282
  544239
  554848
  556757
  561511
  564298
  577266
  584177
  590544
  599809
  602050
  616675
  625887
  631865
  635615
  642276
  695367
  695393
  703942
  712690
  712691
  713432
  714539
  715444
  715605
  721890
  725196
  725201
  725481
  729000
  729294
  729297
  731095
  731800
  733526
  738396
  738420
  739484
  740230
  740239
  740878
  742780
  745865
  748495
  749592
  753029
  757176
  765877
  766608
  774076
  780672
  794842
  794854
  795046
  803875
  806309
  818761
  823446
  823739
  824088
  824259
  824350
  824415
  824707
  824743
  824763
  825070
  825071
  825164
  825166
  825268
  826217
  826691
  826712
  826891
  827408
  828799
]
15.09 ms
(8.20%)
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
  511083
  45799
  388726
  396349
  446900
  487753
  635615
  455530
  483642
  506274
  519344
  493195
  116623
  213598
  391956
  352187
  25650
  61313
  396043
  397633
  428064
  823739
  824088
  826217
  826691
  818761
  824707
  824743
  825268
  826891
  827408
  823446
  824763
  825071
  825164
  825166
  824259
  824350
  824415
  825070
  826712
  828799
  466902
  530122
  531801
  496324
  539660
  522503
  531858
  533317
  534624
  535744
  544239
  561511
  584177
  543135
  543282
  543152
  556757
  564298
  577266
  695393
  712691
  695367
  713432
  712690
  715444
  715605
  721890
  554848
  599809
  631865
  642276
  590544
  616675
  625887
  794854
  795046
  806309
  725201
  749592
  774076
  794842
  803875
  725196
  725481
  729294
  731095
  731800
  740230
  745865
  748495
  765877
  729297
  733526
  738420
  740239
  738396
  739484
  740878
  742780
  729000
  753029
  757176
  766608
  602050
  703942
  714539
  780672
  382321
  382671
  269287
  388284
  385855
  383109
  153249
  187418
  191117
  102334
  111260
]
2.65 ms
(1.44%)
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
  25650
  45799
  61313
  102334
  111260
  116623
  153249
  187418
  191117
  213598
  269287
  352187
  382321
  382671
  383109
  385855
  388284
  388726
  391956
  396043
  396349
  397633
  428064
  446900
  455530
  466902
  483642
  487753
  493195
  496324
  506274
  511083
  519344
  522503
  530122
  531801
  531858
  533317
  534624
  535744
  539660
  543135
  543152
  543282
  544239
  554848
  556757
  561511
  564298
  577266
  584177
  590544
  599809
  602050
  616675
  625887
  631865
  635615
  642276
  695367
  695393
  703942
  712690
  712691
  713432
  714539
  715444
  715605
  721890
  725196
  725201
  725481
  729000
  729294
  729297
  731095
  731800
  733526
  738396
  738420
  739484
  740230
  740239
  740878
  742780
  745865
  748495
  749592
  753029
  757176
  765877
  766608
  774076
  780672
  794842
  794854
  795046
  803875
  806309
  818761
  823446
  823739
  824088
  824259
  824350
  824415
  824707
  824743
  824763
  825070
  825071
  825164
  825166
  825268
  826217
  826691
  826712
  826891
  827408
  828799
]
1.80 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy chubby"
]
1.67 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак chubby"
]
1.40 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак chubby"
]

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.