Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.09 ms
(87.74%)
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
  457962
  458012
  461138
  461701
  471375
  471647
  475855
  477208
  494676
  497496
  498753
  504441
  509631
  511648
  512207
  520000
  520595
  521558
  522505
  522545
  522958
  523641
  524510
  526321
  526408
  528909
  536928
  538222
  539473
  540729
  540888
  542373
  544566
  545250
  547618
  547872
  549064
  549572
  550459
  550997
  551511
  551653
  553505
  557349
  559723
  559733
  560288
  560382
  560506
  561300
  564019
  564393
  564747
  567059
  567527
  567616
  569056
  569536
  572988
  573714
  574456
  579556
  580126
  581667
  582532
  584082
  585250
  586185
  586807
  588941
  589617
  590121
  591060
  591462
  591561
  591992
  592089
  593988
  594557
  596617
  597508
  597872
  600800
  601281
  604332
  604527
  604996
  605905
  606683
  607412
  608354
  610054
  612179
  613961
  615063
  616602
  616790
  616937
  619333
  619865
  619919
  621540
  621593
  621849
  624255
  624287
  624795
  625030
  627061
  641482
  644206
  646049
  656117
  659793
  671659
  673074
  687937
  722050
  764247
  812372
]
11.36 ms
(6.47%)
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
  475855
  540729
  520595
  521558
  497496
  522505
  524510
  536928
  526321
  477208
  564019
  547618
  550459
  551511
  580126
  567527
  659793
  671659
  547872
  550997
  553505
  559723
  567059
  581667
  584082
  588941
  592089
  600800
  613961
  619333
  644206
  601281
  604332
  606683
  616937
  590121
  593988
  604527
  621593
  538222
  540888
  549064
  461701
  471375
  471647
  457962
  458012
  498753
  526408
  539473
  520000
  523641
  528909
  504441
  511648
  522958
  494676
  509631
  512207
  522545
  461138
  557349
  559733
  560288
  569536
  574456
  542373
  545250
  549572
  564747
  573714
  582532
  544566
  551653
  560382
  564393
  567616
  646049
  673074
  656117
  687937
  560506
  561300
  569056
  572988
  579556
  585250
  605905
  612179
  586185
  589617
  591060
  591462
  591992
  594557
  608354
  616790
  619919
  621540
  625030
  641482
  597508
  616602
  624287
  586807
  591561
  596617
  597872
  604996
  624795
  812372
  764247
  607412
  610054
  615063
  619865
  621849
  624255
  627061
  722050
]
3.00 ms
(1.71%)
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
  457962
  458012
  461138
  461701
  471375
  471647
  475855
  477208
  494676
  497496
  498753
  504441
  509631
  511648
  512207
  520000
  520595
  521558
  522505
  522545
  522958
  523641
  524510
  526321
  526408
  528909
  536928
  538222
  539473
  540729
  540888
  542373
  544566
  545250
  547618
  547872
  549064
  549572
  550459
  550997
  551511
  551653
  553505
  557349
  559723
  559733
  560288
  560382
  560506
  561300
  564019
  564393
  564747
  567059
  567527
  567616
  569056
  569536
  572988
  573714
  574456
  579556
  580126
  581667
  582532
  584082
  585250
  586185
  586807
  588941
  589617
  590121
  591060
  591462
  591561
  591992
  592089
  593988
  594557
  596617
  597508
  597872
  600800
  601281
  604332
  604527
  604996
  605905
  606683
  607412
  608354
  610054
  612179
  613961
  615063
  616602
  616790
  616937
  619333
  619865
  619919
  621540
  621593
  621849
  624255
  624287
  624795
  625030
  627061
  641482
  644206
  646049
  656117
  659793
  671659
  673074
  687937
  722050
  764247
  812372
]
2.07 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "трах бедро"
]
1.89 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс бедр"
]
1.59 ms
(0.91%)
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.