Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
276.01 ms
(90.49%)
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
  168687
  396331
  398976
  400495
  418795
  418896
  420157
  421831
  421876
  421885
  428783
  433051
  433792
  433888
  434629
  434839
  435108
  439431
  439731
  441158
  444750
  444919
  445087
  450301
  453967
  455513
  456067
  456581
  458152
  459298
  461036
  462350
  463032
  463456
  463460
  468916
  475224
  475552
  478652
  483188
  484247
  487932
  489381
  500031
  500605
  501957
  503834
  505578
  505983
  506693
  509043
  512950
  513847
  514847
  515759
  516968
  517680
  518004
  518627
  519611
  520165
  520761
  521175
  522433
  522626
  524139
  524176
  526494
  526687
  527685
  528322
  528584
  529618
  530448
  536406
  538119
  542383
  550522
  551908
  551935
  558216
  559979
  562941
  563330
  572250
  578693
  582499
  584171
  584229
  585193
  585454
  587468
  588404
  589310
  596897
  600794
  601414
  602883
  603768
  606907
  612687
  621457
  626659
  628267
  632722
  636355
  639670
  661989
  671219
  674350
  674905
  722422
  760411
  764123
  778229
  781011
  801249
  801653
  812298
  812547
]
20.33 ms
(6.66%)
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
  801653
  456067
  456581
  512950
  661989
  475224
  418896
  421831
  421876
  462350
  530448
  528322
  572250
  606907
  396331
  400495
  484247
  418795
  489381
  168687
  439431
  563330
  596897
  801249
  671219
  441158
  639670
  434839
  450301
  463460
  453967
  521175
  526687
  517680
  538119
  463032
  578693
  584229
  550522
  674350
  628267
  589310
  636355
  600794
  433051
  434629
  503834
  500031
  558216
  506693
  513847
  487932
  674905
  778229
  516968
  522433
  542383
  585454
  621457
  444919
  527685
  515759
  522626
  514847
  562941
  468916
  444750
  551935
  603768
  518004
  398976
  459298
  433888
  435108
  439731
  509043
  518627
  526494
  461036
  524176
  588404
  520165
  585193
  505578
  529618
  601414
  524139
  428783
  520761
  420157
  483188
  536406
  612687
  602883
  433792
  584171
  505983
  551908
  722422
  587468
  626659
  781011
  764123
  812547
  760411
  445087
  455513
  559979
  582499
  458152
  501957
  519611
  500605
  812298
  632722
  528584
  463456
  475552
  421885
  478652
]
2.79 ms
(0.92%)
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
  168687
  396331
  398976
  400495
  418795
  418896
  420157
  421831
  421876
  421885
  428783
  433051
  433792
  433888
  434629
  434839
  435108
  439431
  439731
  441158
  444750
  444919
  445087
  450301
  453967
  455513
  456067
  456581
  458152
  459298
  461036
  462350
  463032
  463456
  463460
  468916
  475224
  475552
  478652
  483188
  484247
  487932
  489381
  500031
  500605
  501957
  503834
  505578
  505983
  506693
  509043
  512950
  513847
  514847
  515759
  516968
  517680
  518004
  518627
  519611
  520165
  520761
  521175
  522433
  522626
  524139
  524176
  526494
  526687
  527685
  528322
  528584
  529618
  530448
  536406
  538119
  542383
  550522
  551908
  551935
  558216
  559979
  562941
  563330
  572250
  578693
  582499
  584171
  584229
  585193
  585454
  587468
  588404
  589310
  596897
  600794
  601414
  602883
  603768
  606907
  612687
  621457
  626659
  628267
  632722
  636355
  639670
  661989
  671219
  674350
  674905
  722422
  760411
  764123
  778229
  781011
  801249
  801653
  812298
  812547
]
1.65 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "замужние раком в трус%…"
]
1.48 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен рак в трусик нижн бел"
]
1.38 ms
(0.45%)
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.