Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.11 ms
(83.24%)
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
  118109
  410051
  411201
  414374
  415776
  418145
  419933
  420125
  427447
  439558
  443323
  446745
  447978
  451044
  452014
  452255
  453409
  455898
  457064
  464887
  468035
  468072
  480800
  484673
  484692
  488734
  489243
  489424
  495273
  517710
  518403
  519592
  528682
  531118
  531123
  531251
  532674
  532680
  532760
  532954
  532995
  533363
  533373
  533563
  533837
  533846
  536359
  536582
  537204
  537675
  542954
  543659
  543840
  544825
  544838
  545444
  545611
  556046
  559453
  565245
  582179
  582540
  585744
  590230
  593105
  598859
  599861
  599967
  600257
  600360
  615716
  617411
  624193
  628327
  628334
  628371
  630635
  634118
  634769
  635215
  635224
  635243
  636315
  636985
  637044
  639334
  639712
  639798
  639818
  640751
  640813
  641955
  642066
  642660
  642706
  643067
  643098
  644925
  645861
  648241
  648257
  648795
  648839
  649953
  651631
  666525
  673838
  674959
  676022
  676023
  676024
  678126
  678514
  678522
  678532
  679774
  696582
  722373
  742926
  820772
]
19.96 ms
(11.14%)
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
  676024
  674959
  678514
  637044
  634118
  453409
  411201
  468072
  673838
  624193
  636315
  489424
  565245
  630635
  640813
  420125
  644925
  532995
  518403
  531118
  531251
  533373
  532674
  544825
  651631
  635224
  585744
  615716
  533363
  451044
  582179
  593105
  532954
  537675
  559453
  648795
  648839
  722373
  599861
  628327
  642066
  415776
  427447
  446745
  447978
  489243
  533837
  544838
  696582
  590230
  742926
  468035
  488734
  118109
  533563
  543659
  679774
  628371
  443323
  536582
  545444
  556046
  676022
  639818
  642706
  639798
  635215
  439558
  495273
  457064
  532680
  649953
  645861
  639334
  642660
  636985
  484673
  484692
  517710
  418145
  419933
  532760
  536359
  537204
  533846
  528682
  678126
  678532
  676023
  582540
  628334
  641955
  639712
  643067
  643098
  640751
  410051
  414374
  666525
  617411
  634769
  464887
  519592
  542954
  545611
  678522
  648241
  635243
  600360
  598859
  600257
  480800
  452255
  648257
  820772
  599967
  452014
  455898
  531123
  543840
]
3.05 ms
(1.70%)
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
  118109
  410051
  411201
  414374
  415776
  418145
  419933
  420125
  427447
  439558
  443323
  446745
  447978
  451044
  452014
  452255
  453409
  455898
  457064
  464887
  468035
  468072
  480800
  484673
  484692
  488734
  489243
  489424
  495273
  517710
  518403
  519592
  528682
  531118
  531123
  531251
  532674
  532680
  532760
  532954
  532995
  533363
  533373
  533563
  533837
  533846
  536359
  536582
  537204
  537675
  542954
  543659
  543840
  544825
  544838
  545444
  545611
  556046
  559453
  565245
  582179
  582540
  585744
  590230
  593105
  598859
  599861
  599967
  600257
  600360
  615716
  617411
  624193
  628327
  628334
  628371
  630635
  634118
  634769
  635215
  635224
  635243
  636315
  636985
  637044
  639334
  639712
  639798
  639818
  640751
  640813
  641955
  642066
  642660
  642706
  643067
  643098
  644925
  645861
  648241
  648257
  648795
  648839
  649953
  651631
  666525
  673838
  674959
  676022
  676023
  676024
  678126
  678514
  678522
  678532
  679774
  696582
  722373
  742926
  820772
]
2.03 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal pussy fisting"
]
1.78 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.98%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал pussy фистинг"
]
1.44 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал 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.