Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.24 ms
(85.69%)
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
  182185
  383952
  386156
  389479
  391915
  391994
  397685
  398097
  408885
  410962
  414137
  416683
  416722
  416731
  417601
  419619
  420774
  423763
  429859
  438207
  445216
  450077
  450518
  450969
  458359
  462848
  463435
  467097
  468949
  469221
  473213
  485472
  487281
  489331
  495481
  502789
  510729
  511240
  511857
  511869
  519722
  520491
  520495
  521238
  521831
  523406
  527677
  528775
  535295
  535963
  536641
  542422
  547801
  550952
  556445
  561909
  561952
  562222
  567063
  567245
  568075
  577520
  579649
  582582
  585229
  592621
  592662
  600031
  601862
  602846
  607560
  613515
  614968
  614979
  617473
  620323
  625633
  627446
  631728
  636732
  638671
  638885
  640312
  640353
  642165
  647383
  656801
  659219
  669583
  680816
  681242
  709838
  714294
  739810
  741186
  744028
  751285
  758318
  760319
  767731
  777752
  780195
  780266
  784681
  786017
  790629
  791026
  792148
  796673
  796996
  803632
  803931
  806495
  806826
  806904
  807170
  812493
  825864
  828725
]
16.13 ms
(8.63%)
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
  585229
  592621
  602846
  614968
  520491
  528775
  419619
  613515
  744028
  523406
  458359
  182185
  567245
  659219
  647383
  656801
  631728
  640312
  617473
  642165
  669583
  751285
  520495
  601862
  638885
  408885
  450969
  468949
  536641
  485472
  567063
  577520
  620323
  760319
  627446
  467097
  416683
  416722
  521238
  489331
  782835
  389479
  511240
  469221
  410962
  414137
  511857
  681242
  386156
  429859
  582582
  825864
  391915
  398097
  714294
  600031
  640353
  790629
  792148
  777752
  780266
  796673
  796996
  807170
  741186
  786017
  812493
  767731
  758318
  709838
  780195
  791026
  803632
  803931
  806495
  806826
  806904
  445216
  397685
  562222
  680816
  638671
  592662
  739810
  561952
  420774
  450518
  542422
  547801
  561909
  568075
  556445
  636732
  784681
  607560
  450077
  438207
  495481
  416731
  487281
  462848
  473213
  502789
  511869
  519722
  550952
  579649
  614979
  625633
  391994
  423763
  463435
  510729
  828725
  383952
  521831
  417601
  535295
  527677
  535963
]
3.43 ms
(1.84%)
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
  182185
  383952
  386156
  389479
  391915
  391994
  397685
  398097
  408885
  410962
  414137
  416683
  416722
  416731
  417601
  419619
  420774
  423763
  429859
  438207
  445216
  450077
  450518
  450969
  458359
  462848
  463435
  467097
  468949
  469221
  473213
  485472
  487281
  489331
  495481
  502789
  510729
  511240
  511857
  511869
  519722
  520491
  520495
  521238
  521831
  523406
  527677
  528775
  535295
  535963
  536641
  542422
  547801
  550952
  556445
  561909
  561952
  562222
  567063
  567245
  568075
  577520
  579649
  582582
  585229
  592621
  592662
  600031
  601862
  602846
  607560
  613515
  614968
  614979
  617473
  620323
  625633
  627446
  631728
  636732
  638671
  638885
  640312
  640353
  642165
  647383
  656801
  659219
  669583
  680816
  681242
  709838
  714294
  739810
  741186
  744028
  751285
  758318
  760319
  767731
  777752
  780195
  780266
  784681
  786017
  790629
  791026
  792148
  796673
  796996
  803632
  803931
  806495
  806826
  806904
  807170
  812493
  825864
  828725
]
2.06 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo public amateur"
]
1.85 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд на улиц любительск"
]
1.57 ms
(0.84%)
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.