Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.09 ms
(80.81%)
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
  383402
  383912
  388557
  422292
  422484
  422673
  439732
  440906
  443738
  448828
  452319
  453259
  453701
  454052
  454199
  454846
  457004
  459154
  459158
  459630
  460633
  462322
  464372
  465707
  469509
  470502
  471414
  474661
  474685
  481282
  482074
  482790
  494496
  502819
  508812
  511911
  512416
  512513
  516047
  518325
  518881
  522200
  526228
  528088
  541781
  543544
  544321
  546446
  553356
  554497
  555987
  557494
  560319
  560376
  563410
  567434
  584744
  592843
  593005
  597722
  598862
  605999
  606396
  608439
  611307
  611329
  625176
  641671
  665461
  667196
  673357
  674091
  710386
  714613
  714771
  718279
  718472
  724280
  726396
  728496
  729781
  736010
  739672
  742575
  744101
  747101
  747128
  747216
  749620
  756070
  756231
  761436
  766403
  769949
  772691
  773073
  774141
  774364
  774376
  774406
  775569
  775605
  780707
  789471
  795961
  796246
  797703
  799050
  800342
  802095
  807016
  807639
  808649
  809189
  809752
  810061
  823806
  826587
  826761
  826934
]
20.56 ms
(13.07%)
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
  541781
  641671
  459154
  439732
  470502
  462322
  512513
  443738
  543544
  802095
  809189
  775569
  795961
  608439
  459630
  454199
  560376
  555987
  563410
  584744
  597722
  728496
  454052
  453701
  511911
  516047
  518325
  518881
  440906
  528088
  452319
  454846
  422673
  508812
  494496
  774406
  826587
  775605
  774376
  453259
  799050
  826761
  544321
  718279
  807639
  797703
  807016
  756070
  736010
  773073
  774364
  724280
  774141
  567434
  592843
  383912
  422484
  826934
  823806
  459158
  457004
  481282
  522200
  471414
  557494
  560319
  714613
  714771
  710386
  674091
  553356
  625176
  593005
  611329
  598862
  780707
  809752
  742575
  756231
  766403
  769949
  747216
  761436
  605999
  808649
  512416
  502819
  772691
  448828
  482790
  464372
  469509
  474661
  474685
  526228
  383402
  422292
  546446
  554497
  718472
  606396
  729781
  739672
  726396
  747101
  747128
  796246
  800342
  744101
  749620
  789471
  460633
  465707
  482074
  667196
  665461
  673357
  611307
  810061
  388557
]
2.75 ms
(1.75%)
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
  383402
  383912
  388557
  422292
  422484
  422673
  439732
  440906
  443738
  448828
  452319
  453259
  453701
  454052
  454199
  454846
  457004
  459154
  459158
  459630
  460633
  462322
  464372
  465707
  469509
  470502
  471414
  474661
  474685
  481282
  482074
  482790
  494496
  502819
  508812
  511911
  512416
  512513
  516047
  518325
  518881
  522200
  526228
  528088
  541781
  543544
  544321
  546446
  553356
  554497
  555987
  557494
  560319
  560376
  563410
  567434
  584744
  592843
  593005
  597722
  598862
  605999
  606396
  608439
  611307
  611329
  625176
  641671
  665461
  667196
  673357
  674091
  710386
  714613
  714771
  718279
  718472
  724280
  726396
  728496
  729781
  736010
  739672
  742575
  744101
  747101
  747128
  747216
  749620
  756070
  756231
  761436
  766403
  769949
  772691
  773073
  774141
  774364
  774376
  774406
  775569
  775605
  780707
  789471
  795961
  796246
  797703
  799050
  800342
  802095
  807016
  807639
  808649
  809189
  809752
  810061
  823806
  826587
  826761
  826934
]
2.05 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "дрочит три зрелых"
]
1.75 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк зрелая женщин"
]
1.60 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.94%)
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.