Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.46 ms
(84.31%)
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
  88664
  96021
  96371
  311897
  388424
  405468
  405712
  415905
  434327
  437733
  440906
  444743
  444795
  446703
  446958
  448816
  451266
  456661
  459139
  470278
  471668
  473395
  474126
  477812
  478463
  479818
  482375
  482773
  483946
  491183
  494181
  495126
  495800
  500506
  504085
  510884
  511196
  520492
  520953
  521438
  523568
  526553
  530039
  530375
  530383
  530476
  530497
  530765
  530789
  530854
  531103
  531107
  531173
  531208
  531248
  531304
  532737
  532748
  532779
  532837
  532906
  532960
  536259
  536266
  536281
  536608
  537663
  537902
  540575
  545648
  556483
  563992
  564201
  567062
  572022
  580160
  586933
  598675
  599102
  599894
  599916
  601575
  611572
  613018
  631203
  633767
  642033
  644962
  649583
  650333
  655575
  668151
  676092
  677232
  699526
  704236
  704529
  723618
  723620
  728540
  728567
  737473
  743455
  747468
  750568
  752610
  752645
  753124
  754902
  762222
  777982
  778393
  780189
  792606
  792741
  802899
  808155
  808691
  813579
  814971
]
22.96 ms
(11.16%)
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
  737473
  752610
  753124
  762222
  728567
  728540
  743455
  752645
  754902
  778393
  792741
  437733
  388424
  434327
  520953
  495800
  491183
  530039
  530383
  531208
  532737
  530476
  531173
  532837
  530789
  676092
  704529
  470278
  415905
  494181
  510884
  479818
  556483
  459139
  483946
  96371
  405468
  440906
  813579
  474126
  478463
  500506
  532906
  536281
  523568
  530375
  530765
  531304
  532748
  536259
  530854
  536266
  540575
  537902
  563992
  650333
  699526
  599102
  613018
  642033
  704236
  446958
  451266
  456661
  473395
  520492
  677232
  655575
  780189
  777982
  444743
  723618
  814971
  482773
  495126
  530497
  531103
  531248
  511196
  567062
  580160
  649583
  598675
  599894
  633767
  599916
  601575
  611572
  631203
  808155
  792606
  802899
  808691
  747468
  750568
  311897
  446703
  668151
  96021
  88664
  444795
  471668
  537663
  526553
  572022
  564201
  504085
  586933
  448816
  521438
  405712
  723620
  644962
  482375
  532779
  536608
  531107
  532960
  477812
  545648
]
2.52 ms
(1.22%)
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
  88664
  96021
  96371
  311897
  388424
  405468
  405712
  415905
  434327
  437733
  440906
  444743
  444795
  446703
  446958
  448816
  451266
  456661
  459139
  470278
  471668
  473395
  474126
  477812
  478463
  479818
  482375
  482773
  483946
  491183
  494181
  495126
  495800
  500506
  504085
  510884
  511196
  520492
  520953
  521438
  523568
  526553
  530039
  530375
  530383
  530476
  530497
  530765
  530789
  530854
  531103
  531107
  531173
  531208
  531248
  531304
  532737
  532748
  532779
  532837
  532906
  532960
  536259
  536266
  536281
  536608
  537663
  537902
  540575
  545648
  556483
  563992
  564201
  567062
  572022
  580160
  586933
  598675
  599102
  599894
  599916
  601575
  611572
  613018
  631203
  633767
  642033
  644962
  649583
  650333
  655575
  668151
  676092
  677232
  699526
  704236
  704529
  723618
  723620
  728540
  728567
  737473
  743455
  747468
  750568
  752610
  752645
  753124
  754902
  762222
  777982
  778393
  780189
  792606
  792741
  802899
  808155
  808691
  813579
  814971
]
1.93 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick and dildo"
]
1.70 ms
(0.83%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член дилд"
]
1.66 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.74%)
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.