Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.64 ms
(82.79%)
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
  97377
  207970
  308542
  338371
  339474
  340206
  383250
  385174
  385923
  387372
  387562
  388474
  389176
  395489
  396334
  396565
  396728
  397208
  397980
  399156
  407483
  408238
  410954
  414069
  418864
  419631
  419896
  419911
  421054
  421129
  421152
  426390
  431405
  432777
  433968
  437519
  440692
  445431
  448650
  449907
  452388
  454785
  455085
  455851
  455856
  457936
  465639
  466412
  466426
  466738
  467109
  467120
  469187
  469262
  472393
  472603
  473461
  474322
  475326
  475797
  478006
  478526
  479071
  480779
  481047
  485152
  488551
  491465
  492338
  496060
  497725
  506279
  512534
  527464
  528406
  533575
  541316
  543918
  549387
  550316
  551260
  552703
  556951
  562340
  565132
  570830
  580438
  582346
  586890
  592377
  592959
  605612
  612959
  613751
  615812
  616534
  629893
  629899
  641490
  642727
  650011
  674068
  681313
  687605
  697969
  710767
  711281
  727577
  732867
  739772
  748034
  757443
  765470
  767371
  788267
  799721
  804171
  812873
  819177
  824344
]
18.64 ms
(11.46%)
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
  338371
  340206
  414069
  419911
  431405
  419896
  418864
  457936
  469187
  475797
  491465
  449907
  467109
  445431
  455856
  472603
  512534
  465639
  479071
  549387
  551260
  580438
  582346
  650011
  612959
  804171
  389176
  387562
  421129
  454785
  472393
  562340
  385174
  433968
  385923
  207970
  339474
  397980
  819177
  824344
  533575
  687605
  616534
  641490
  748034
  732867
  739772
  711281
  399156
  387372
  437519
  474322
  492338
  455851
  496060
  527464
  552703
  541316
  556951
  565132
  710767
  681313
  550316
  586890
  592959
  592377
  615812
  629893
  629899
  799721
  473461
  481047
  388474
  455085
  478526
  485152
  528406
  488551
  605612
  467120
  475326
  674068
  613751
  757443
  767371
  788267
  765470
  727577
  642727
  697969
  812873
  395489
  308542
  397208
  407483
  410954
  408238
  426390
  419631
  421054
  432777
  440692
  466426
  448650
  480779
  466412
  466738
  469262
  570830
  396565
  421152
  452388
  478006
  97377
  383250
  396334
  396728
  506279
  497725
  543918
]
2.47 ms
(1.52%)
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
  97377
  207970
  308542
  338371
  339474
  340206
  383250
  385174
  385923
  387372
  387562
  388474
  389176
  395489
  396334
  396565
  396728
  397208
  397980
  399156
  407483
  408238
  410954
  414069
  418864
  419631
  419896
  419911
  421054
  421129
  421152
  426390
  431405
  432777
  433968
  437519
  440692
  445431
  448650
  449907
  452388
  454785
  455085
  455851
  455856
  457936
  465639
  466412
  466426
  466738
  467109
  467120
  469187
  469262
  472393
  472603
  473461
  474322
  475326
  475797
  478006
  478526
  479071
  480779
  481047
  485152
  488551
  491465
  492338
  496060
  497725
  506279
  512534
  527464
  528406
  533575
  541316
  543918
  549387
  550316
  551260
  552703
  556951
  562340
  565132
  570830
  580438
  582346
  586890
  592377
  592959
  605612
  612959
  613751
  615812
  616534
  629893
  629899
  641490
  642727
  650011
  674068
  681313
  687605
  697969
  710767
  711281
  727577
  732867
  739772
  748034
  757443
  765470
  767371
  788267
  799721
  804171
  812873
  819177
  824344
]
2.14 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "compilation interracial"
]
1.79 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк межрасов"
]
1.36 ms
(0.83%)
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.