Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
187.07 ms
(89.54%)
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
  20907
  21108
  167822
  172340
  182526
  184909
  213136
  265847
  272904
  387527
  389182
  400854
  401507
  401513
  414248
  418428
  418540
  419140
  422506
  422924
  423010
  423080
  423398
  424918
  425366
  428267
  428913
  429652
  429949
  431497
  443523
  443582
  446478
  446480
  458834
  459262
  460950
  468616
  468753
  471168
  472949
  473774
  477408
  485046
  491453
  492637
  510571
  512178
  515279
  530667
  533126
  539095
  540310
  540313
  550138
  550523
  550771
  551975
  551988
  552002
  552034
  552934
  554157
  554789
  556384
  557844
  559876
  566465
  566485
  573213
  582669
  585381
  587979
  593287
  595056
  597263
  600455
  605397
  607763
  608009
  613163
  622646
  649107
  650951
  651667
  653846
  662060
  667402
  673044
  683458
  685814
  694195
  698283
  698477
  702438
  712184
  713197
  724590
  729857
  730559
  730579
  740831
  743069
  746624
  748672
  753212
  755365
  759051
  763322
  772087
  777426
  785782
  788141
  788257
  795691
  795708
  810416
  813794
  826104
  828414
]
11.49 ms
(5.50%)
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
  595056
  743069
  753212
  763322
  724590
  748672
  622646
  401507
  650951
  729857
  777426
  414248
  826104
  184909
  21108
  458834
  460950
  556384
  566465
  685814
  712184
  673044
  713197
  607763
  795708
  431497
  550523
  600455
  740831
  730579
  702438
  422506
  422924
  550138
  515279
  387527
  418540
  419140
  428267
  443582
  428913
  446480
  477408
  468616
  473774
  540310
  540313
  552002
  582669
  573213
  605397
  810416
  468753
  443523
  472949
  485046
  530667
  423010
  597263
  446478
  539095
  651667
  400854
  533126
  585381
  608009
  423080
  423398
  213136
  389182
  492637
  551975
  552934
  566485
  550771
  557844
  662060
  649107
  653846
  683458
  694195
  698477
  667402
  593287
  587979
  788141
  795691
  759051
  730559
  746624
  755365
  772087
  698283
  785782
  167822
  20907
  418428
  429949
  471168
  491453
  554157
  559876
  554789
  551988
  552034
  613163
  182526
  429652
  424918
  425366
  401513
  828414
  459262
  788257
  510571
  172340
  265847
  272904
  813794
  512178
]
2.89 ms
(1.38%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "азиатк девушк xxx"
]
2.52 ms
(1.21%)
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
  20907
  21108
  167822
  172340
  182526
  184909
  213136
  265847
  272904
  387527
  389182
  400854
  401507
  401513
  414248
  418428
  418540
  419140
  422506
  422924
  423010
  423080
  423398
  424918
  425366
  428267
  428913
  429652
  429949
  431497
  443523
  443582
  446478
  446480
  458834
  459262
  460950
  468616
  468753
  471168
  472949
  473774
  477408
  485046
  491453
  492637
  510571
  512178
  515279
  530667
  533126
  539095
  540310
  540313
  550138
  550523
  550771
  551975
  551988
  552002
  552034
  552934
  554157
  554789
  556384
  557844
  559876
  566465
  566485
  573213
  582669
  585381
  587979
  593287
  595056
  597263
  600455
  605397
  607763
  608009
  613163
  622646
  649107
  650951
  651667
  653846
  662060
  667402
  673044
  683458
  685814
  694195
  698283
  698477
  702438
  712184
  713197
  724590
  729857
  730559
  730579
  740831
  743069
  746624
  748672
  753212
  755365
  759051
  763322
  772087
  777426
  785782
  788141
  788257
  795691
  795708
  810416
  813794
  826104
  828414
]
2.08 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian girl xxx"
]
1.52 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "азиатк девушк xxx"
]

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.