Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
220.16 ms
(91.05%)
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
  76172
  310758
  382918
  393865
  395439
  395541
  395556
  396534
  396952
  408773
  411334
  413280
  421814
  426525
  429245
  429737
  432517
  433681
  435592
  435931
  443713
  443719
  447687
  450672
  455298
  457379
  460195
  465240
  465300
  465589
  467312
  468843
  472163
  472583
  472650
  478376
  483554
  486928
  487984
  506127
  508431
  516886
  518004
  518976
  521137
  525170
  526392
  539917
  549356
  551646
  551824
  552285
  556661
  561805
  565921
  565974
  579123
  581714
  587507
  595103
  600023
  601052
  603750
  604941
  605480
  606945
  612051
  637752
  637758
  673136
  673582
  676591
  687419
  689036
  710310
  718694
  721632
  730710
  734456
  735319
  736493
  740141
  741001
  755447
  756429
  756816
  757063
  757415
  758279
  770003
  770190
  770226
  770871
  772549
  772584
  782993
  783290
  784221
  788413
  790076
  791710
  795658
  796661
  800028
  800662
  801081
  802467
  802687
  809078
  809277
  810071
  810790
  811481
  813628
  814372
  816972
  817885
  822266
  822990
  825924
]
12.39 ms
(5.12%)
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
  811481
  730710
  734456
  741001
  770871
  772584
  782993
  788413
  800028
  802467
  802687
  810071
  735319
  736493
  770003
  755447
  757415
  770190
  772549
  740141
  756429
  756816
  758279
  606945
  637752
  718694
  791710
  795658
  796661
  809277
  408773
  483554
  556661
  468843
  516886
  396952
  790076
  801081
  770226
  581714
  551824
  579123
  565974
  689036
  612051
  784221
  411334
  429737
  472163
  518976
  676591
  435592
  393865
  432517
  382918
  551646
  600023
  605480
  800662
  443719
  465300
  450672
  673136
  710310
  757063
  721632
  429245
  465589
  506127
  508431
  472583
  604941
  809078
  810790
  413280
  521137
  526392
  518004
  76172
  310758
  426525
  433681
  435931
  457379
  465240
  455298
  525170
  539917
  460195
  472650
  552285
  561805
  549356
  673582
  687419
  565921
  587507
  595103
  603750
  601052
  637758
  478376
  467312
  396534
  421814
  447687
  487984
  486928
  783290
  443713
  395556
  395439
  395541
  816972
  817885
  822266
  822990
  813628
  825924
  814372
]
2.87 ms
(1.19%)
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
  76172
  310758
  382918
  393865
  395439
  395541
  395556
  396534
  396952
  408773
  411334
  413280
  421814
  426525
  429245
  429737
  432517
  433681
  435592
  435931
  443713
  443719
  447687
  450672
  455298
  457379
  460195
  465240
  465300
  465589
  467312
  468843
  472163
  472583
  472650
  478376
  483554
  486928
  487984
  506127
  508431
  516886
  518004
  518976
  521137
  525170
  526392
  539917
  549356
  551646
  551824
  552285
  556661
  561805
  565921
  565974
  579123
  581714
  587507
  595103
  600023
  601052
  603750
  604941
  605480
  606945
  612051
  637752
  637758
  673136
  673582
  676591
  687419
  689036
  710310
  718694
  721632
  730710
  734456
  735319
  736493
  740141
  741001
  755447
  756429
  756816
  757063
  757415
  758279
  770003
  770190
  770226
  770871
  772549
  772584
  782993
  783290
  784221
  788413
  790076
  791710
  795658
  796661
  800028
  800662
  801081
  802467
  802687
  809078
  809277
  810071
  810790
  811481
  813628
  814372
  816972
  817885
  822266
  822990
  825924
]
1.89 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom трусик нижн бел"
]
1.81 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom in panties"
]
1.45 ms
(0.60%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.23 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom трусик нижн бел"
]

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.