Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
186.90 ms
(89.43%)
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
  391527
  391994
  392006
  415294
  416683
  417030
  417396
  428375
  432949
  432963
  436132
  438191
  438532
  441162
  446251
  448575
  448604
  450373
  452978
  457071
  459731
  465670
  467588
  470034
  471110
  488559
  493700
  494097
  498483
  499302
  500313
  510729
  511137
  511140
  511455
  511857
  513522
  518614
  520913
  524964
  531583
  531586
  536800
  541377
  544404
  548170
  555063
  555101
  555565
  557650
  561909
  562052
  564102
  564744
  567063
  569593
  571726
  573734
  578857
  587312
  595646
  596649
  597534
  601460
  614979
  617045
  617604
  619636
  621755
  627446
  666969
  671479
  679491
  691179
  693310
  703619
  703945
  704072
  704700
  705451
  712580
  715584
  736813
  738926
  739113
  741119
  742364
  742681
  751309
  760238
  766401
  766433
  772579
  776829
  778266
  780192
  781250
  782547
  784671
  785814
  785982
  791206
  791212
  792700
  792735
  794041
  799725
  800442
  801628
  806527
  808337
  808548
  811100
  814989
  816176
  824191
  827181
  827692
]
13.10 ms
(6.27%)
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
  392006
  614979
  391994
  438191
  448604
  510729
  452978
  827181
  555565
  488559
  498483
  511137
  617045
  541377
  557650
  704072
  705451
  715584
  776829
  782547
  785814
  785982
  808337
  811100
  766401
  736813
  742364
  742681
  703945
  780192
  792700
  792735
  799725
  459731
  578857
  471110
  417396
  567063
  627446
  415294
  467588
  416683
  500313
  691179
  816176
  428375
  573734
  432949
  666969
  619636
  555063
  693310
  601460
  781250
  794041
  806505
  807147
  808548
  760238
  704700
  806527
  571726
  511857
  470034
  450373
  561909
  417030
  465670
  391527
  536800
  494097
  548170
  562052
  544404
  564744
  595646
  587312
  597534
  499302
  520913
  531586
  524964
  518614
  596649
  436132
  511455
  827692
  824191
  569593
  800442
  446251
  457071
  513522
  432963
  814989
  531583
  511140
  493700
  564102
  555101
  703619
  679491
  671479
  712580
  617604
  621755
  778266
  791212
  741119
  766433
  772579
  784671
  801628
  739113
  751309
  738926
  791206
  448575
  441162
  438532
]
2.43 ms
(1.16%)
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
  391527
  391994
  392006
  415294
  416683
  417030
  417396
  428375
  432949
  432963
  436132
  438191
  438532
  441162
  446251
  448575
  448604
  450373
  452978
  457071
  459731
  465670
  467588
  470034
  471110
  488559
  493700
  494097
  498483
  499302
  500313
  510729
  511137
  511140
  511455
  511857
  513522
  518614
  520913
  524964
  531583
  531586
  536800
  541377
  544404
  548170
  555063
  555101
  555565
  557650
  561909
  562052
  564102
  564744
  567063
  569593
  571726
  573734
  578857
  587312
  595646
  596649
  597534
  601460
  614979
  617045
  617604
  619636
  621755
  627446
  666969
  671479
  679491
  691179
  693310
  703619
  703945
  704072
  704700
  705451
  712580
  715584
  736813
  738926
  739113
  741119
  742364
  742681
  751309
  760238
  766401
  766433
  772579
  776829
  778266
  780192
  781250
  782547
  784671
  785814
  785982
  791206
  791212
  792700
  792735
  794041
  799725
  800442
  801628
  806527
  808337
  808548
  811100
  814989
  816176
  824191
  827181
  827692
]
1.90 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian homemade dildo"
]
1.74 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск домашн любительск дилд"
]
1.46 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск домашн любительск дилд"
]
1.46 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.