Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.40 ms
(88.04%)
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
  88591
  145706
  182285
  388110
  416694
  420904
  424265
  426144
  438013
  439274
  449186
  454509
  457071
  459656
  460441
  464687
  466524
  466860
  471312
  476049
  476216
  479883
  482498
  484108
  487428
  487535
  488559
  488907
  490399
  492399
  495319
  504337
  511388
  514657
  515979
  516120
  517975
  520146
  520813
  520913
  520922
  522231
  523622
  525355
  525992
  527675
  532442
  534035
  537035
  537378
  540889
  541284
  541409
  546358
  546723
  547229
  547767
  551869
  552312
  554369
  554371
  555024
  556448
  559828
  560508
  560694
  561909
  561910
  564744
  567063
  569341
  569594
  571222
  572530
  581310
  584021
  584153
  584817
  586161
  591604
  592650
  592681
  592945
  594201
  594946
  595646
  597036
  599004
  600853
  602147
  604870
  605857
  605906
  607509
  615296
  615693
  616857
  617003
  617047
  626037
  632090
  638806
  680468
  695869
  704221
  711771
  722384
  733446
  733450
  745345
  755481
  775161
  786874
  789490
  791504
  794210
  799027
  802903
  812486
  812749
]
13.20 ms
(7.38%)
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
  476049
  515979
  520913
  527675
  487535
  733450
  537378
  88591
  482498
  522231
  523622
  532442
  464687
  541284
  546723
  547229
  546358
  569594
  552312
  554371
  560694
  561909
  569341
  680468
  695869
  711771
  722384
  556448
  559828
  564744
  571222
  572530
  581310
  584021
  592650
  595646
  602147
  592681
  605857
  626037
  632090
  599004
  604870
  605906
  607509
  586161
  591604
  592945
  597036
  617003
  617047
  638806
  786874
  794210
  802903
  812749
  733446
  745345
  615693
  616857
  704221
  791504
  799027
  420904
  471312
  424265
  439274
  449186
  525355
  487428
  490399
  511388
  514657
  517975
  520813
  520922
  488907
  520146
  460441
  466524
  516120
  466860
  561910
  567063
  584153
  584817
  615296
  789490
  755481
  457071
  388110
  488559
  525992
  504337
  145706
  600853
  775161
  182285
  479883
  416694
  459656
  454509
  495319
  534035
  547767
  594201
  812486
  476216
  426144
  438013
  484108
  540889
  594946
  492399
  537035
  541409
  560508
  551869
  554369
  555024
]
2.33 ms
(1.30%)
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
  88591
  145706
  182285
  388110
  416694
  420904
  424265
  426144
  438013
  439274
  449186
  454509
  457071
  459656
  460441
  464687
  466524
  466860
  471312
  476049
  476216
  479883
  482498
  484108
  487428
  487535
  488559
  488907
  490399
  492399
  495319
  504337
  511388
  514657
  515979
  516120
  517975
  520146
  520813
  520913
  520922
  522231
  523622
  525355
  525992
  527675
  532442
  534035
  537035
  537378
  540889
  541284
  541409
  546358
  546723
  547229
  547767
  551869
  552312
  554369
  554371
  555024
  556448
  559828
  560508
  560694
  561909
  561910
  564744
  567063
  569341
  569594
  571222
  572530
  581310
  584021
  584153
  584817
  586161
  591604
  592650
  592681
  592945
  594201
  594946
  595646
  597036
  599004
  600853
  602147
  604870
  605857
  605906
  607509
  615296
  615693
  616857
  617003
  617047
  626037
  632090
  638806
  680468
  695869
  704221
  711771
  722384
  733446
  733450
  745345
  755481
  775161
  786874
  789490
  791504
  794210
  799027
  802903
  812486
  812749
]
1.61 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "herself masturbation"
]
1.58 ms
(0.89%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "herself мастурбац"
]
1.22 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "herself мастурбац"
]

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.