Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.74 ms
(52.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тёлочки в трусиках и к…"
]
161.33 ms
(40.65%)
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
  102147
  386273
  389304
  389658
  396672
  397719
  399500
  400880
  402965
  403392
  417438
  418915
  419351
  420847
  421443
  421822
  426113
  426708
  426936
  427631
  432568
  432731
  433904
  433920
  436530
  436830
  438708
  441285
  441466
  441793
  443841
  444078
  444750
  444843
  444919
  445827
  446212
  448284
  449525
  450448
  450540
  451254
  452182
  452676
  453761
  455425
  456556
  456840
  457684
  458487
  458826
  459016
  459401
  460379
  460908
  462624
  463464
  463547
  464156
  464915
  465846
  465926
  467667
  468864
  468876
  473320
  475027
  478547
  478901
  479379
  481351
  481539
  484860
  485056
  485250
  485613
  487984
  490133
  494851
  500652
  500922
  503712
  504946
  504960
  506021
  506986
  507281
  507887
  509640
  510350
  512165
  514786
  516246
  516493
  516835
  518542
  520025
  523848
  523999
  526358
  527064
  527319
  528112
  536274
  538367
  541913
  543353
  546633
  556997
  557442
  567087
  568980
  572929
  573834
  574006
  575420
  580024
  582354
  584108
  593194
]
18.03 ms
(4.54%)
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
  490133
  504960
  389304
  420847
  484860
  396672
  473320
  400880
  509640
  478547
  580024
  584108
  426936
  449525
  487984
  418915
  441285
  465846
  389658
  467667
  463547
  432731
  479379
  456840
  102147
  403392
  426113
  475027
  464156
  436530
  397719
  444078
  536274
  444750
  507281
  528112
  399500
  468876
  506021
  573834
  464915
  500922
  518542
  451254
  445827
  514786
  512165
  452676
  463464
  507887
  443841
  478901
  485056
  572929
  557442
  438708
  441793
  481539
  485613
  541913
  386273
  500652
  575420
  421822
  427631
  456556
  450448
  527064
  465926
  450540
  526358
  444919
  453761
  527319
  593194
  436830
  417438
  516493
  448284
  460908
  543353
  432568
  567087
  520025
  523999
  433904
  402965
  468864
  481351
  433920
  510350
  452182
  457684
  462624
  546633
  568980
  419351
  485250
  523848
  503712
  516835
  455425
  458487
  459016
  458826
  426708
  421443
  556997
  504946
  459401
  516246
  444843
  494851
  582354
  574006
  446212
  460379
  538367
  441466
  506986
]
4.01 ms
(1.01%)
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
  102147
  386273
  389304
  389658
  396672
  397719
  399500
  400880
  402965
  403392
  417438
  418915
  419351
  420847
  421443
  421822
  426113
  426708
  426936
  427631
  432568
  432731
  433904
  433920
  436530
  436830
  438708
  441285
  441466
  441793
  443841
  444078
  444750
  444843
  444919
  445827
  446212
  448284
  449525
  450448
  450540
  451254
  452182
  452676
  453761
  455425
  456556
  456840
  457684
  458487
  458826
  459016
  459401
  460379
  460908
  462624
  463464
  463547
  464156
  464915
  465846
  465926
  467667
  468864
  468876
  473320
  475027
  478547
  478901
  479379
  481351
  481539
  484860
  485056
  485250
  485613
  487984
  490133
  494851
  500652
  500922
  503712
  504946
  504960
  506021
  506986
  507281
  507887
  509640
  510350
  512165
  514786
  516246
  516493
  516835
  518542
  520025
  523848
  523999
  526358
  527064
  527319
  528112
  536274
  538367
  541913
  543353
  546633
  556997
  557442
  567087
  568980
  572929
  573834
  574006
  575420
  580024
  582354
  584108
  593194
]
2.01 ms
(0.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "женскийрод в трусик нижн бел"
]
1.90 ms
(0.48%)
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.