Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
160.54 ms
(85.24%)
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
  13282
  187851
  188031
  211045
  305824
  366354
  381929
  382398
  382926
  387284
  388578
  388930
  389819
  390857
  391017
  392013
  392181
  392480
  395988
  397601
  397919
  398615
  401807
  402042
  405811
  407732
  417070
  417238
  417370
  418052
  418072
  418530
  420277
  421817
  425150
  426998
  427655
  427911
  428064
  428089
  429834
  432408
  432470
  433619
  437148
  439292
  439808
  441583
  441770
  441957
  442623
  445240
  447160
  452290
  454468
  454472
  454701
  454957
  455352
  456166
  456338
  459638
  460348
  460377
  460545
  463991
  467028
  468211
  468291
  468495
  469147
  472299
  473431
  473471
  475177
  475853
  477144
  483635
  485429
  496891
  500377
  502696
  503476
  506233
  509151
  509264
  514755
  515596
  519122
  527197
  532306
  549725
  579711
  580572
  584939
  588439
  591705
  626186
  642563
  645481
  646421
  715444
  720051
  728060
  728337
  738396
  738419
  742494
  742633
  749621
  759747
  769292
  781994
  789162
  795566
  795998
  796503
  803875
  806944
  811708
]
17.14 ms
(9.10%)
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
  515596
  439292
  519122
  389819
  532306
  381929
  591705
  477144
  305824
  459638
  13282
  456166
  468291
  460377
  475177
  769292
  397919
  426998
  433619
  417370
  387284
  395988
  549725
  421817
  646421
  432470
  472299
  418052
  720051
  427911
  496891
  728060
  473471
  781994
  580572
  738419
  454468
  447160
  418530
  429834
  460348
  485429
  382398
  509264
  502696
  759747
  749621
  392480
  417238
  452290
  742633
  469147
  427655
  432408
  390857
  366354
  401807
  503476
  188031
  441583
  467028
  514755
  397601
  407732
  460545
  392013
  428089
  506233
  588439
  468495
  509151
  500377
  420277
  439808
  391017
  579711
  645481
  715444
  584939
  626186
  642563
  796503
  811708
  803875
  738396
  742494
  795566
  463991
  402042
  417070
  454472
  454701
  795998
  211045
  468211
  425150
  789162
  728337
  437148
  483635
  428064
  806944
  382926
  187851
  455352
  473431
  398615
  475853
  445240
  388578
  441770
  442623
  441957
  418072
  405811
  454957
  388930
  456338
  527197
  392181
]
2.98 ms
(1.58%)
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
  13282
  187851
  188031
  211045
  305824
  366354
  381929
  382398
  382926
  387284
  388578
  388930
  389819
  390857
  391017
  392013
  392181
  392480
  395988
  397601
  397919
  398615
  401807
  402042
  405811
  407732
  417070
  417238
  417370
  418052
  418072
  418530
  420277
  421817
  425150
  426998
  427655
  427911
  428064
  428089
  429834
  432408
  432470
  433619
  437148
  439292
  439808
  441583
  441770
  441957
  442623
  445240
  447160
  452290
  454468
  454472
  454701
  454957
  455352
  456166
  456338
  459638
  460348
  460377
  460545
  463991
  467028
  468211
  468291
  468495
  469147
  472299
  473431
  473471
  475177
  475853
  477144
  483635
  485429
  496891
  500377
  502696
  503476
  506233
  509151
  509264
  514755
  515596
  519122
  527197
  532306
  549725
  579711
  580572
  584939
  588439
  591705
  626186
  642563
  645481
  646421
  715444
  720051
  728060
  728337
  738396
  738419
  742494
  742633
  749621
  759747
  769292
  781994
  789162
  795566
  795998
  796503
  803875
  806944
  811708
]
2.52 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "толстую задница раком…"
]
1.75 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "толстая жоп рак"
]
1.73 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.