Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.99 ms
(86.54%)
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
  391156
  391654
  395899
  396887
  398544
  400807
  409942
  411593
  411948
  446624
  446629
  447157
  447163
  452232
  454225
  454267
  455910
  460340
  461016
  463171
  464960
  466077
  467035
  471887
  474120
  474400
  474826
  480480
  483368
  484643
  484702
  485752
  486835
  487933
  489495
  493093
  498722
  502034
  504823
  507659
  511664
  513333
  513785
  518848
  518864
  518869
  519143
  519151
  519752
  524887
  526843
  537148
  539460
  549245
  558286
  566171
  580667
  663391
  663901
  663935
  664283
  664793
  665235
  665305
  665479
  665513
  665835
  665857
  666153
  666766
  666770
  667294
  667517
  667607
  667615
  672796
  678778
  678790
  695283
  701444
  714647
  717700
  718563
  721475
  724276
  725341
  728481
  745055
  746112
  748379
  758439
  775972
  781679
  781709
  781734
  781748
  784248
  788276
  788285
  788787
  788822
  789363
  789527
  789530
  789665
  790596
  794629
  800700
  800771
  802409
  807626
  811087
  816781
  817410
  817417
  817956
  824452
  824934
  825037
  825140
]
16.55 ms
(8.42%)
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
  452232
  480480
  460340
  511664
  519151
  485752
  513785
  519143
  487933
  519752
  484702
  493093
  507659
  513333
  518864
  518869
  395899
  396887
  398544
  539460
  665857
  667517
  701444
  672796
  721475
  714647
  781734
  802409
  781709
  788787
  789527
  794629
  724276
  788276
  745055
  746112
  391654
  411948
  446624
  447157
  447163
  455910
  464960
  474826
  446629
  474400
  489495
  461016
  518848
  502034
  524887
  467035
  483368
  558286
  666766
  775972
  400807
  463171
  466077
  454225
  454267
  526843
  484643
  504823
  580667
  486835
  817410
  817956
  817417
  824934
  816781
  824452
  825140
  471887
  566171
  663391
  663901
  665513
  664283
  665835
  666770
  667615
  695283
  718563
  781748
  784248
  789530
  811087
  725341
  748379
  788822
  789363
  790596
  800700
  800771
  758439
  728481
  781679
  788285
  807626
  549245
  678778
  678790
  789665
  391156
  474120
  498722
  409942
  411593
  825037
  537148
  665479
  666153
  667294
  667607
  717700
  663935
  664793
  665235
  665305
]
2.63 ms
(1.34%)
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
  391156
  391654
  395899
  396887
  398544
  400807
  409942
  411593
  411948
  446624
  446629
  447157
  447163
  452232
  454225
  454267
  455910
  460340
  461016
  463171
  464960
  466077
  467035
  471887
  474120
  474400
  474826
  480480
  483368
  484643
  484702
  485752
  486835
  487933
  489495
  493093
  498722
  502034
  504823
  507659
  511664
  513333
  513785
  518848
  518864
  518869
  519143
  519151
  519752
  524887
  526843
  537148
  539460
  549245
  558286
  566171
  580667
  663391
  663901
  663935
  664283
  664793
  665235
  665305
  665479
  665513
  665835
  665857
  666153
  666766
  666770
  667294
  667517
  667607
  667615
  672796
  678778
  678790
  695283
  701444
  714647
  717700
  718563
  721475
  724276
  725341
  728481
  745055
  746112
  748379
  758439
  775972
  781679
  781709
  781734
  781748
  784248
  788276
  788285
  788787
  788822
  789363
  789527
  789530
  789665
  790596
  794629
  800700
  800771
  802409
  807626
  811087
  816781
  817410
  817417
  817956
  824452
  824934
  825037
  825140
]
2.09 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "старые бабушк"
]
1.92 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "старые бабки"
]
1.63 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.82%)
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.