Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.04 ms
(78.46%)
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
  14602
  106162
  109043
  212183
  271756
  274678
  326305
  381828
  382437
  385228
  385476
  391871
  392760
  393700
  393737
  396226
  396757
  396894
  397329
  399515
  399689
  399828
  400418
  400434
  400458
  400714
  400715
  401714
  401976
  411218
  412713
  413288
  413468
  414361
  414498
  417362
  418485
  421519
  422711
  425223
  427449
  427523
  428364
  428543
  429249
  430713
  432887
  435498
  437448
  437939
  443370
  446480
  447661
  448927
  449109
  450779
  452413
  453530
  454195
  458855
  459811
  462356
  462961
  463114
  464925
  465639
  465652
  467169
  469079
  469415
  469594
  469844
  471448
  474060
  474385
  475020
  475869
  476310
  477553
  477699
  485600
  487481
  489245
  489796
  495159
  497524
  504829
  508109
  509075
  515106
  522079
  522699
  549296
  549387
  551137
  555112
  556425
  556844
  557983
  559707
  560188
  560202
  562361
  565617
  567380
  567605
  575778
  581700
  589148
  593440
  594807
  597561
  603954
  605515
  609196
  609278
  612751
  613836
  620882
  624430
]
21.57 ms
(13.99%)
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
  557983
  399828
  422711
  504829
  551137
  560188
  613836
  589148
  609196
  609278
  603954
  567380
  562361
  620882
  624430
  385476
  385228
  392760
  271756
  381828
  14602
  396226
  400714
  400418
  400458
  400715
  401976
  411218
  413468
  421519
  430713
  437939
  412713
  417362
  418485
  427449
  428543
  435498
  443370
  427523
  446480
  453530
  462356
  463114
  489245
  489796
  448927
  459811
  477553
  447661
  454195
  462961
  469415
  508109
  495159
  465639
  469079
  469594
  475869
  476310
  549387
  549296
  559707
  555112
  556425
  556844
  581700
  593440
  594807
  597561
  605515
  109043
  326305
  391871
  393700
  414498
  425223
  428364
  429249
  458855
  467169
  474060
  477699
  106162
  382437
  396894
  400434
  413288
  465652
  212183
  274678
  397329
  399689
  437448
  471448
  474385
  393737
  396757
  399515
  401714
  432887
  449109
  452413
  464925
  469844
  475020
  414361
  450779
  485600
  509075
  487481
  522699
  497524
  515106
  522079
  565617
  575778
  560202
  567605
  612751
]
3.02 ms
(1.96%)
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
  14602
  106162
  109043
  212183
  271756
  274678
  326305
  381828
  382437
  385228
  385476
  391871
  392760
  393700
  393737
  396226
  396757
  396894
  397329
  399515
  399689
  399828
  400418
  400434
  400458
  400714
  400715
  401714
  401976
  411218
  412713
  413288
  413468
  414361
  414498
  417362
  418485
  421519
  422711
  425223
  427449
  427523
  428364
  428543
  429249
  430713
  432887
  435498
  437448
  437939
  443370
  446480
  447661
  448927
  449109
  450779
  452413
  453530
  454195
  458855
  459811
  462356
  462961
  463114
  464925
  465639
  465652
  467169
  469079
  469415
  469594
  469844
  471448
  474060
  474385
  475020
  475869
  476310
  477553
  477699
  485600
  487481
  489245
  489796
  495159
  497524
  504829
  508109
  509075
  515106
  522079
  522699
  549296
  549387
  551137
  555112
  556425
  556844
  557983
  559707
  560188
  560202
  562361
  565617
  567380
  567605
  575778
  581700
  589148
  593440
  594807
  597561
  603954
  605515
  609196
  609278
  612751
  613836
  620882
  624430
]
2.67 ms
(1.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ÐâðÂð©ð║ Ðü ð╝ÐâðÂð©ð║ð¥ð╝ ð© ð▒ð░ð▒ð%ÔǪ"
]
2.17 ms
(1.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мужчин мужчин женскийрод"
]
2.00 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(1.16%)
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.