Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.89 ms
(87.18%)
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
  180923
  383358
  389740
  446352
  447974
  450148
  452946
  458782
  465903
  468285
  469365
  469873
  478816
  480273
  489620
  490806
  493023
  495736
  496343
  496781
  504060
  506878
  507032
  507128
  507204
  509829
  515083
  521736
  522158
  524260
  524494
  524634
  525829
  526480
  526893
  528762
  528874
  528995
  529372
  531016
  531297
  531701
  534724
  535145
  535490
  536871
  537783
  539429
  539619
  540973
  542153
  543530
  544276
  544310
  544342
  544832
  545881
  547207
  547358
  549816
  549961
  550154
  552212
  553278
  554058
  554156
  554453
  554525
  555146
  556337
  557497
  558785
  559806
  561761
  562290
  563934
  564490
  566335
  566643
  566728
  571817
  574438
  577570
  579255
  586636
  591222
  592472
  593087
  595684
  597118
  598867
  601513
  603213
  604182
  604422
  607255
  610024
  611304
  615048
  615202
  616587
  616996
  617353
  619845
  622029
  629370
  630428
  632288
  632859
  634848
  635266
  636139
  636230
  644512
  644688
  644885
  732422
  775540
  775593
  812537
]
14.17 ms
(7.49%)
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
  592472
  595684
  610024
  611304
  615202
  617353
  644688
  604422
  622029
  632859
  586636
  593087
  598867
  601513
  607255
  616587
  634848
  635266
  591222
  597118
  603213
  604182
  619845
  630428
  636230
  775593
  732422
  615048
  629370
  632288
  636139
  644512
  775540
  812537
  180923
  446352
  447974
  458782
  389740
  452946
  480273
  468285
  526480
  616996
  383358
  644885
  469365
  478816
  490806
  493023
  469873
  450148
  489620
  507128
  524634
  525829
  535490
  495736
  496343
  504060
  507204
  522158
  524260
  528762
  528874
  528995
  529372
  531016
  506878
  507032
  524494
  535145
  536871
  537783
  539619
  496781
  509829
  515083
  521736
  526893
  531297
  531701
  534724
  539429
  465903
  544832
  545881
  547207
  547358
  549816
  549961
  553278
  554058
  559806
  563934
  564490
  566643
  571817
  574438
  543530
  544310
  550154
  562290
  577570
  579255
  540973
  542153
  544276
  544342
  552212
  554156
  554453
  554525
  555146
  556337
  557497
  558785
  561761
  566335
  566728
]
2.79 ms
(1.48%)
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
  180923
  383358
  389740
  446352
  447974
  450148
  452946
  458782
  465903
  468285
  469365
  469873
  478816
  480273
  489620
  490806
  493023
  495736
  496343
  496781
  504060
  506878
  507032
  507128
  507204
  509829
  515083
  521736
  522158
  524260
  524494
  524634
  525829
  526480
  526893
  528762
  528874
  528995
  529372
  531016
  531297
  531701
  534724
  535145
  535490
  536871
  537783
  539429
  539619
  540973
  542153
  543530
  544276
  544310
  544342
  544832
  545881
  547207
  547358
  549816
  549961
  550154
  552212
  553278
  554058
  554156
  554453
  554525
  555146
  556337
  557497
  558785
  559806
  561761
  562290
  563934
  564490
  566335
  566643
  566728
  571817
  574438
  577570
  579255
  586636
  591222
  592472
  593087
  595684
  597118
  598867
  601513
  603213
  604182
  604422
  607255
  610024
  611304
  615048
  615202
  616587
  616996
  617353
  619845
  622029
  629370
  630428
  632288
  632859
  634848
  635266
  636139
  636230
  644512
  644688
  644885
  732422
  775540
  775593
  812537
]
2.01 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ше"
]
1.96 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "шеи"
]
1.89 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.75%)
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.