Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
449.59 ms
(95.07%)
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
  7791
  20907
  39126
  82252
  105023
  129857
  151014
  214602
  220774
  233274
  242127
  365735
  382165
  382297
  383508
  385908
  386782
  388098
  388228
  388796
  393424
  396215
  398309
  417234
  426893
  449259
  451309
  457934
  463072
  464619
  471715
  479576
  494886
  521537
  528657
  533229
  536065
  545551
  551242
  556172
  559219
  570595
  578530
  579921
  580608
  580769
  587155
  590105
  602177
  605408
  605684
  609965
  617964
  622701
  635415
  640149
  640336
  645194
  650007
  650348
  651333
  660863
  663834
  665490
  666848
  667314
  672891
  677343
  680386
  683584
  684458
  684488
  692805
  701302
  702446
  703062
  713705
  715754
  722850
  724120
  724605
  726423
  726728
  729142
  730144
  732802
  734403
  744277
  748489
  750628
  751044
  756628
  757318
  757363
  764807
  767960
  768716
  773131
  774883
  779765
  780268
  782852
  784612
  784970
  789129
  790461
  791394
  800579
  802471
  804335
  804882
  805189
  805808
  807235
  814974
  820765
  827033
  828000
]
13.48 ms
(2.85%)
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
  827033
  677343
  715754
  580608
  587155
  805189
  800579
  802471
  805808
  724605
  764807
  724120
  744277
  730144
  713705
  220774
  105023
  7791
  233274
  463072
  521537
  665490
  385908
  383508
  242127
  39126
  388098
  426893
  551242
  570595
  672891
  663834
  666848
  667314
  692805
  722850
  579921
  605408
  609965
  617964
  622701
  784612
  784970
  773131
  726728
  780268
  791394
  382297
  396215
  388228
  494886
  732802
  580769
  756628
  388796
  814974
  645194
  464619
  365735
  20907
  559219
  683584
  703062
  457934
  528657
  151014
  820765
  660863
  701302
  702446
  129857
  393424
  417234
  828000
  449259
  479576
  451309
  533229
  536065
  471715
  556172
  573937
  545551
  578530
  651333
  680386
  684488
  650348
  650007
  684458
  602177
  605684
  590105
  640149
  640336
  774883
  779765
  782852
  786867
  807235
  804335
  729142
  734403
  750628
  757363
  751044
  767960
  768716
  748489
  757318
  726423
  635415
  789129
  790461
  804882
  386782
  82252
  214602
  382165
  398309
]
3.41 ms
(0.72%)
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
  7791
  20907
  39126
  82252
  105023
  129857
  151014
  214602
  220774
  233274
  242127
  365735
  382165
  382297
  383508
  385908
  386782
  388098
  388228
  388796
  393424
  396215
  398309
  417234
  426893
  449259
  451309
  457934
  463072
  464619
  471715
  479576
  494886
  521537
  528657
  533229
  536065
  545551
  551242
  556172
  559219
  570595
  578530
  579921
  580608
  580769
  587155
  590105
  602177
  605408
  605684
  609965
  617964
  622701
  635415
  640149
  640336
  645194
  650007
  650348
  651333
  660863
  663834
  665490
  666848
  667314
  672891
  677343
  680386
  683584
  684458
  684488
  692805
  701302
  702446
  703062
  713705
  715754
  722850
  724120
  724605
  726423
  726728
  729142
  730144
  732802
  734403
  744277
  748489
  750628
  751044
  756628
  757318
  757363
  764807
  767960
  768716
  773131
  774883
  779765
  780268
  782852
  784612
  784970
  789129
  790461
  791394
  800579
  802471
  804335
  804882
  805189
  805808
  807235
  814974
  820765
  827033
  828000
]
1.82 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding sex pussy"
]
1.80 ms
(0.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.34%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding секс pussy"
]
1.19 ms
(0.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "riding секс pussy"
]

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.