Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
219.10 ms
(86.37%)
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
  396404
  421826
  421847
  439720
  459756
  466094
  469027
  469522
  473846
  473908
  474414
  477631
  479147
  481501
  482360
  483448
  485100
  485548
  486963
  490944
  491348
  493132
  495253
  503418
  503491
  503506
  508293
  509338
  509637
  512539
  515258
  515931
  516210
  516281
  516940
  517067
  517143
  518500
  518577
  518958
  519616
  519618
  519653
  520937
  521300
  522744
  522997
  523766
  526669
  527144
  527670
  527852
  528524
  529293
  529340
  529376
  530513
  534612
  535414
  538949
  539753
  540553
  541185
  542247
  543317
  548316
  549680
  549692
  551761
  554258
  556990
  556994
  557486
  559332
  561077
  561560
  561758
  562834
  563440
  566002
  570174
  570747
  570952
  573911
  576648
  581616
  582235
  582243
  583837
  586566
  587578
  592993
  597839
  601113
  601333
  602102
  603310
  603830
  604185
  604631
  605415
  605529
  606132
  607709
  609220
  612381
  615749
  617129
  617781
  621402
  626546
  626549
  628696
  629363
  645920
  663458
  665113
  678716
  678804
  689610
]
17.00 ms
(6.70%)
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
  469027
  473846
  474414
  477631
  481501
  495253
  518500
  522997
  539753
  503506
  509637
  516940
  518577
  519616
  527144
  538949
  515258
  518958
  519653
  523766
  526669
  527852
  528524
  529340
  503418
  509338
  515931
  517143
  534612
  540553
  482360
  541185
  542247
  549692
  554258
  556990
  556994
  561758
  566002
  570747
  582235
  583837
  548316
  551761
  573911
  576648
  543317
  549680
  557486
  561077
  562834
  570174
  678716
  645920
  665113
  689610
  559332
  561560
  570952
  582243
  601113
  603310
  603830
  605529
  586566
  587578
  592993
  602102
  604185
  615749
  617129
  601333
  621402
  626549
  628696
  597839
  605415
  606132
  607709
  617781
  626546
  604631
  609220
  629363
  396404
  421847
  459756
  469522
  479147
  421826
  439720
  473908
  503491
  520937
  522744
  527670
  483448
  493132
  508293
  516281
  485548
  519618
  521300
  529376
  535414
  516210
  486963
  485100
  512539
  517067
  663458
  678804
  612381
  466094
  529293
  491348
  530513
  563440
  581616
  490944
]
9.85 ms
(3.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.30 ms
(0.90%)
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
  396404
  421826
  421847
  439720
  459756
  466094
  469027
  469522
  473846
  473908
  474414
  477631
  479147
  481501
  482360
  483448
  485100
  485548
  486963
  490944
  491348
  493132
  495253
  503418
  503491
  503506
  508293
  509338
  509637
  512539
  515258
  515931
  516210
  516281
  516940
  517067
  517143
  518500
  518577
  518958
  519616
  519618
  519653
  520937
  521300
  522744
  522997
  523766
  526669
  527144
  527670
  527852
  528524
  529293
  529340
  529376
  530513
  534612
  535414
  538949
  539753
  540553
  541185
  542247
  543317
  548316
  549680
  549692
  551761
  554258
  556990
  556994
  557486
  559332
  561077
  561560
  561758
  562834
  563440
  566002
  570174
  570747
  570952
  573911
  576648
  581616
  582235
  582243
  583837
  586566
  587578
  592993
  597839
  601113
  601333
  602102
  603310
  603830
  604185
  604631
  605415
  605529
  606132
  607709
  609220
  612381
  615749
  617129
  617781
  621402
  626546
  626549
  628696
  629363
  645920
  663458
  665113
  678716
  678804
  689610
]
1.95 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature юбк"
]
1.75 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature skirt"
]
1.73 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature юбк"
]

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.