Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.45 ms
(88.08%)
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
  6920
  365912
  388350
  396825
  417384
  420351
  422285
  424560
  428595
  428596
  432723
  433898
  435263
  438095
  441698
  442143
  442964
  444387
  444926
  445756
  445784
  446611
  447247
  447735
  448229
  448622
  451050
  451139
  454652
  456648
  457174
  457850
  459565
  459736
  459942
  460379
  463501
  464578
  467762
  468188
  469016
  472132
  474053
  474601
  475381
  478140
  479878
  481251
  484230
  488454
  489034
  490250
  491936
  492921
  498364
  498874
  507715
  508367
  508492
  509672
  510475
  511141
  511367
  511683
  514977
  515590
  519383
  519715
  520329
  520344
  521049
  521622
  521901
  521919
  524759
  525451
  525541
  526415
  526609
  527366
  528144
  548850
  548866
  549134
  550463
  550469
  551158
  554201
  557422
  557665
  561303
  564423
  567409
  574521
  575071
  575161
  575470
  575754
  578333
  586595
  588277
  606910
  609772
  613155
  620626
  632014
  653467
  654200
  661571
  661977
  674216
  677042
  691242
  693576
  694415
  730642
  732029
  739953
  801786
  818459
]
19.56 ms
(8.03%)
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
  674216
  730642
  609772
  613155
  801786
  435263
  459736
  396825
  654200
  441698
  447735
  478140
  444926
  454652
  515590
  420351
  433898
  432723
  428596
  488454
  520329
  498874
  557665
  694415
  550463
  588277
  732029
  445784
  468188
  519383
  528144
  818459
  507715
  677042
  739953
  6920
  388350
  365912
  519715
  549134
  514977
  511141
  511367
  521901
  459565
  575470
  620626
  474601
  467762
  661977
  475381
  428595
  457174
  457850
  472132
  469016
  511683
  524759
  463501
  548850
  578333
  564423
  567409
  661571
  606910
  632014
  479878
  445756
  451050
  424560
  448622
  451139
  526609
  490250
  525541
  526415
  527366
  491936
  520344
  521622
  521919
  510475
  489034
  464578
  474053
  575071
  551158
  554201
  557422
  550469
  574521
  693576
  691242
  575754
  442143
  460379
  481251
  459942
  508367
  509672
  422285
  442964
  417384
  521049
  561303
  548866
  456648
  446611
  444387
  448229
  498364
  484230
  653467
  525451
  438095
  508492
  447247
  575161
  586595
  492921
]
3.28 ms
(1.35%)
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
  6920
  365912
  388350
  396825
  417384
  420351
  422285
  424560
  428595
  428596
  432723
  433898
  435263
  438095
  441698
  442143
  442964
  444387
  444926
  445756
  445784
  446611
  447247
  447735
  448229
  448622
  451050
  451139
  454652
  456648
  457174
  457850
  459565
  459736
  459942
  460379
  463501
  464578
  467762
  468188
  469016
  472132
  474053
  474601
  475381
  478140
  479878
  481251
  484230
  488454
  489034
  490250
  491936
  492921
  498364
  498874
  507715
  508367
  508492
  509672
  510475
  511141
  511367
  511683
  514977
  515590
  519383
  519715
  520329
  520344
  521049
  521622
  521901
  521919
  524759
  525451
  525541
  526415
  526609
  527366
  528144
  548850
  548866
  549134
  550463
  550469
  551158
  554201
  557422
  557665
  561303
  564423
  567409
  574521
  575071
  575161
  575470
  575754
  578333
  586595
  588277
  606910
  609772
  613155
  620626
  632014
  653467
  654200
  661571
  661977
  674216
  677042
  691242
  693576
  694415
  730642
  732029
  739953
  801786
  818459
]
1.84 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful girlfriend ass"
]
1.54 ms
(0.63%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая girlfriend жоп"
]
1.42 ms
(0.58%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая girlfriend жоп"
]

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.