Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.55 ms
(80.84%)
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
  417828
  423731
  426645
  427299
  430504
  438178
  444645
  446446
  448354
  448695
  452472
  452480
  452483
  453337
  453698
  455207
  456437
  458890
  459180
  470092
  475951
  477773
  486199
  489237
  489349
  491431
  492229
  496259
  498240
  505023
  505584
  506009
  507284
  507514
  508454
  508497
  508510
  508516
  510176
  510815
  511013
  514638
  514644
  514645
  515544
  515645
  516025
  516309
  516938
  519849
  520954
  521818
  522101
  525045
  526005
  526447
  527377
  527967
  528055
  528435
  536466
  537307
  539288
  541630
  541631
  542148
  542516
  542707
  542862
  546042
  550667
  554440
  558201
  559948
  572264
  576080
  580123
  581098
  581530
  583496
  584887
  586180
  586639
  588285
  588724
  590290
  590505
  592988
  593292
  594045
  598870
  599041
  602439
  602846
  603167
  603696
  603994
  604939
  605445
  609604
  612335
  613167
  614975
  619703
  621269
  623727
  623732
  628208
  632794
  652673
]
20.74 ms
(12.37%)
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
  542707
  623732
  586639
  602846
  528055
  586180
  452472
  505023
  453337
  519849
  514645
  603167
  507514
  430504
  508510
  522101
  554440
  603696
  456437
  458890
  417828
  489349
  491431
  505584
  452483
  546042
  446446
  537307
  628208
  542862
  581530
  632794
  609604
  470092
  506009
  510176
  602439
  613167
  426645
  448695
  496259
  527377
  603994
  580123
  452480
  621269
  427299
  588285
  526447
  652673
  590505
  594045
  453698
  492229
  459180
  572264
  581098
  612335
  516025
  515544
  590290
  614975
  511013
  489237
  444645
  514644
  526005
  448354
  507284
  558201
  583496
  588724
  498240
  515645
  508516
  477773
  510815
  604939
  623727
  584887
  598870
  542516
  516309
  516938
  541630
  605445
  508497
  508454
  486199
  619703
  576080
  438178
  542148
  536466
  559948
  593292
  423731
  539288
  520954
  455207
  528435
  525045
  514638
  550667
  599041
  475951
  592988
  541631
  521818
  527967
]
3.55 ms
(2.12%)
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
  417828
  423731
  426645
  427299
  430504
  438178
  444645
  446446
  448354
  448695
  452472
  452480
  452483
  453337
  453698
  455207
  456437
  458890
  459180
  470092
  475951
  477773
  486199
  489237
  489349
  491431
  492229
  496259
  498240
  505023
  505584
  506009
  507284
  507514
  508454
  508497
  508510
  508516
  510176
  510815
  511013
  514638
  514644
  514645
  515544
  515645
  516025
  516309
  516938
  519849
  520954
  521818
  522101
  525045
  526005
  526447
  527377
  527967
  528055
  528435
  536466
  537307
  539288
  541630
  541631
  542148
  542516
  542707
  542862
  546042
  550667
  554440
  558201
  559948
  572264
  576080
  580123
  581098
  581530
  583496
  584887
  586180
  586639
  588285
  588724
  590290
  590505
  592988
  593292
  594045
  598870
  599041
  602439
  602846
  603167
  603696
  603994
  604939
  605445
  609604
  612335
  613167
  614975
  619703
  621269
  623727
  623732
  628208
  632794
  652673
]
2.11 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "девушки в маске"
]
2.01 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк в маск"
]
1.72 ms
(1.03%)
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.