Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.37 ms
(50.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в длинные плат"
]
176.71 ms
(42.29%)
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
  193874
  418034
  420087
  422558
  425687
  430244
  431193
  433789
  436419
  438369
  442360
  443639
  443921
  444134
  445834
  451724
  453167
  454168
  454465
  455344
  455405
  456453
  459715
  462956
  463415
  464491
  465028
  466016
  466666
  468828
  468919
  469276
  470147
  472810
  474468
  474489
  475314
  476518
  477779
  479025
  479549
  481238
  487168
  490653
  492034
  493353
  494031
  494614
  494665
  494736
  496821
  497369
  498643
  498664
  498936
  502299
  502417
  504752
  505613
  506270
  508288
  511745
  512884
  513377
  513948
  514480
  514864
  516637
  518218
  519539
  520412
  521621
  525452
  525806
  529833
  542978
  545977
  548658
  549631
  551876
  558952
  560514
  564424
  566123
  569197
  571374
  573265
  581626
  584203
  584300
  584981
  585731
  587835
  589676
  591672
  593518
  595780
  597927
  599714
  600406
  601138
  601216
  605033
  605257
  609146
  610081
  613163
  614377
  618572
  618754
  620134
  625762
  627822
  628096
  635697
  637517
  639527
  642571
  679166
  783154
]
20.64 ms
(4.94%)
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
  548658
  571374
  584203
  584300
  587835
  600406
  642571
  591672
  609146
  618572
  637517
  599714
  593518
  597927
  625762
  605033
  613163
  627822
  783154
  433789
  442360
  445834
  466016
  468919
  193874
  459715
  477779
  481238
  418034
  425687
  462956
  465028
  479025
  502299
  490653
  506270
  512884
  513377
  493353
  498664
  505613
  494665
  502417
  520412
  585731
  472810
  468828
  516637
  529833
  679166
  601216
  589676
  620134
  479549
  508288
  513948
  518218
  498643
  430244
  453167
  464491
  474489
  454168
  463415
  470147
  454465
  475314
  525806
  504752
  514480
  469276
  564424
  573265
  542978
  566123
  551876
  558952
  581626
  610081
  605257
  618754
  635697
  614377
  639527
  420087
  474468
  476518
  431193
  455344
  456453
  438369
  444134
  422558
  466666
  521621
  494031
  492034
  494614
  494736
  498936
  496821
  519539
  497369
  569197
  595780
  628096
  443639
  487168
  511745
  525452
  560514
  545977
  601138
  514864
  549631
  443921
  436419
  584981
  451724
  455405
]
2.76 ms
(0.66%)
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
  193874
  418034
  420087
  422558
  425687
  430244
  431193
  433789
  436419
  438369
  442360
  443639
  443921
  444134
  445834
  451724
  453167
  454168
  454465
  455344
  455405
  456453
  459715
  462956
  463415
  464491
  465028
  466016
  466666
  468828
  468919
  469276
  470147
  472810
  474468
  474489
  475314
  476518
  477779
  479025
  479549
  481238
  487168
  490653
  492034
  493353
  494031
  494614
  494665
  494736
  496821
  497369
  498643
  498664
  498936
  502299
  502417
  504752
  505613
  506270
  508288
  511745
  512884
  513377
  513948
  514480
  514864
  516637
  518218
  519539
  520412
  521621
  525452
  525806
  529833
  542978
  545977
  548658
  549631
  551876
  558952
  560514
  564424
  566123
  569197
  571374
  573265
  581626
  584203
  584300
  584981
  585731
  587835
  589676
  591672
  593518
  595780
  597927
  599714
  600406
  601138
  601216
  605033
  605257
  609146
  610081
  613163
  614377
  618572
  618754
  620134
  625762
  627822
  628096
  635697
  637517
  639527
  642571
  679166
  783154
]
1.92 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в длинных платьях"
]
1.72 ms
(0.41%)
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.