Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.33 ms
(32.88%)
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
  447205
  486023
  504071
  508976
  545627
  552343
  553024
  556346
  562403
  567855
  573721
  590045
  590276
  599049
  599055
  600937
  605720
  608774
  610218
  616278
  624989
  630369
  630737
  633929
  634320
  635332
  636235
  637317
  641810
  645559
  684778
  684823
  684852
  688142
  688204
  695438
  695456
  703280
  703979
  708073
  708743
  709408
  709512
  710182
  710936
  712141
  715530
  715551
  715591
  715848
  716999
  718639
  718913
  719337
  719628
  719972
  722095
  728490
  729438
  730267
  732403
  734703
  737275
  738015
  738605
  740279
  743918
  744881
  745216
  745644
  748026
  748954
  750242
  751173
  753173
  753978
  755765
  755792
  757116
  757469
  757671
  760670
  762142
  762640
  762714
  762740
  762920
  769280
  771326
  776303
  778167
  778342
  779079
  782403
  784036
  788017
  789391
  789944
  797876
  799800
  807343
  810499
  813097
  814254
  817102
  818073
  818902
  819340
  819376
  819674
  819942
  821828
  824063
  824297
  824536
  825294
  825503
  825619
  826105
]
212.50 ms
(32.60%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "онлифанс социальн сет большие cock"
]
206.18 ms
(31.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "onlyfans big cock"
]
12.82 ms
(1.97%)
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
  710936
  712141
  715591
  716999
  718639
  719337
  778342
  779079
  788017
  789391
  789944
  695456
  637317
  782403
  750242
  486023
  599049
  753978
  599055
  819942
  825503
  684823
  688142
  688204
  715530
  695438
  709408
  684852
  635332
  641810
  616278
  624989
  755765
  810499
  757469
  745644
  744881
  760670
  762740
  762920
  757577
  636235
  719628
  807343
  508976
  645559
  703979
  684778
  703280
  590276
  590045
  730267
  738015
  762714
  630369
  814254
  824536
  826105
  818073
  819376
  573721
  708743
  709512
  718913
  722095
  633929
  608774
  610218
  778167
  813097
  729438
  737275
  743918
  751173
  769280
  755792
  762640
  734703
  757671
  762142
  710182
  504071
  553024
  552343
  757116
  567855
  545627
  784036
  797876
  715551
  562403
  556346
  708073
  719972
  600937
  634320
  630737
  776303
  745216
  740279
  748026
  748954
  771326
  728490
  753173
  447205
  715848
  605720
  799800
  732403
  738605
  821828
  825619
  818902
  825294
  817102
  819340
  819674
  824063
  824297
]
2.69 ms
(0.41%)
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
  447205
  486023
  504071
  508976
  545627
  552343
  553024
  556346
  562403
  567855
  573721
  590045
  590276
  599049
  599055
  600937
  605720
  608774
  610218
  616278
  624989
  630369
  630737
  633929
  634320
  635332
  636235
  637317
  641810
  645559
  684778
  684823
  684852
  688142
  688204
  695438
  695456
  703280
  703979
  708073
  708743
  709408
  709512
  710182
  710936
  712141
  715530
  715551
  715591
  715848
  716999
  718639
  718913
  719337
  719628
  719972
  722095
  728490
  729438
  730267
  732403
  734703
  737275
  738015
  738605
  740279
  743918
  744881
  745216
  745644
  748026
  748954
  750242
  751173
  753173
  753978
  755765
  755792
  757116
  757469
  757671
  760670
  762142
  762640
  762714
  762740
  762920
  769280
  771326
  776303
  778167
  778342
  779079
  782403
  784036
  788017
  789391
  789944
  797876
  799800
  807343
  810499
  813097
  814254
  817102
  818073
  818902
  819340
  819376
  819674
  819942
  821828
  824063
  824297
  824536
  825294
  825503
  825619
  826105
]
1.82 ms
(0.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "онлифанс социальн сет большие cock"
]
1.58 ms
(0.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.