Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.74 ms
(85.65%)
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
  154692
  391954
  409060
  411469
  414349
  418545
  419640
  421257
  445365
  459357
  459883
  461894
  462605
  469833
  479738
  491431
  498525
  499921
  501702
  501703
  502894
  507181
  509643
  511302
  511670
  514240
  516676
  517879
  519374
  524803
  526985
  530214
  534772
  535543
  536716
  537311
  537319
  541106
  547631
  548310
  552989
  553430
  561040
  562012
  562019
  563267
  563728
  576804
  580850
  582330
  582595
  582794
  582833
  583199
  587120
  587445
  589710
  590512
  594159
  597031
  597875
  602821
  609959
  610716
  612265
  624426
  629850
  630666
  631750
  641807
  648741
  650768
  651693
  659015
  660412
  664149
  668701
  695869
  708517
  715460
  715462
  716840
  724459
  724527
  730722
  732184
  734657
  735906
  739125
  745309
  752271
  752633
  752644
  752676
  770225
  770800
  773670
  774699
  774770
  775631
  776209
  776400
  781826
  784681
  787966
  804234
  806302
  808567
  811125
  818922
  819307
  824410
  825064
  825163
  825265
  825834
  826223
  826278
  826627
]
14.27 ms
(8.68%)
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
  582794
  612265
  624426
  631750
  587120
  597031
  491431
  825834
  819307
  409060
  511302
  501703
  587445
  724527
  716840
  770225
  826278
  537311
  498525
  537319
  501702
  526985
  534772
  535543
  459883
  564310
  580850
  583199
  541106
  547631
  552989
  641807
  590512
  776400
  774699
  781826
  752676
  770800
  784681
  811125
  773670
  735906
  752633
  752644
  469833
  421257
  734657
  825163
  548310
  808567
  154692
  514240
  530214
  650768
  775631
  517879
  445365
  479738
  511670
  499921
  507181
  516676
  519374
  553430
  582595
  715462
  660412
  651693
  668701
  695869
  715460
  563267
  804234
  776209
  787966
  739125
  745309
  730722
  391954
  419640
  462605
  509643
  502894
  594159
  630666
  752271
  418545
  826627
  818922
  414349
  582330
  563728
  597875
  610716
  609959
  824410
  826223
  825064
  825265
  806302
  732184
  524803
  459357
  708517
  411469
  536716
  774770
  576804
  659015
  648741
  724459
  629850
  461894
  562019
  562012
  582833
  664149
  561040
  602821
  589710
]
2.47 ms
(1.50%)
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
  154692
  391954
  409060
  411469
  414349
  418545
  419640
  421257
  445365
  459357
  459883
  461894
  462605
  469833
  479738
  491431
  498525
  499921
  501702
  501703
  502894
  507181
  509643
  511302
  511670
  514240
  516676
  517879
  519374
  524803
  526985
  530214
  534772
  535543
  536716
  537311
  537319
  541106
  547631
  548310
  552989
  553430
  561040
  562012
  562019
  563267
  563728
  576804
  580850
  582330
  582595
  582794
  582833
  583199
  587120
  587445
  589710
  590512
  594159
  597031
  597875
  602821
  609959
  610716
  612265
  624426
  629850
  630666
  631750
  641807
  648741
  650768
  651693
  659015
  660412
  664149
  668701
  695869
  708517
  715460
  715462
  716840
  724459
  724527
  730722
  732184
  734657
  735906
  739125
  745309
  752271
  752633
  752644
  752676
  770225
  770800
  773670
  774699
  774770
  775631
  776209
  776400
  781826
  784681
  787966
  804234
  806302
  808567
  811125
  818922
  819307
  824410
  825064
  825163
  825265
  825834
  826223
  826278
  826627
]
2.03 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge boobs homemade"
]
1.66 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные boobs домашн любительск"
]
1.59 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные boobs домашн любительск"
]

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.