Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.58 ms
(83.55%)
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
  142253
  188064
  191265
  233029
  252068
  387782
  388155
  391705
  392076
  397210
  397910
  403426
  404602
  416982
  428456
  428854
  430556
  431117
  439785
  443173
  443691
  444582
  444840
  453262
  454455
  455976
  459215
  464890
  466268
  467602
  477097
  477444
  479425
  482496
  484571
  484648
  484870
  485276
  489275
  492346
  493428
  502738
  516090
  517556
  524940
  532818
  533268
  534239
  536306
  539402
  561589
  562832
  562997
  563083
  563092
  573941
  580017
  591054
  591281
  612574
  612955
  614937
  619070
  627777
  657776
  663260
  671356
  675359
  689945
  689983
  700611
  709204
  711650
  714872
  714908
  718550
  720100
  720517
  723597
  725250
  725365
  725570
  725588
  728231
  728381
  728447
  730163
  731444
  736575
  737372
  739962
  744321
  746553
  747107
  753732
  759566
  759936
  761219
  768290
  778853
  788142
  789176
  789181
  789350
  789366
  789374
  792523
  792539
  793489
  794102
  794403
  795299
  796208
  801426
  802074
  803725
  807475
  814865
]
17.12 ms
(9.96%)
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
  479425
  485276
  464890
  671356
  431117
  502738
  482496
  814865
  484571
  591054
  387782
  517556
  714908
  484648
  489275
  573941
  466268
  477097
  539402
  802074
  768290
  801426
  562997
  430556
  467602
  524940
  562832
  439785
  416982
  779805
  795299
  675359
  725588
  746553
  580017
  663260
  443691
  792539
  403426
  516090
  744321
  391705
  388155
  689983
  725365
  794102
  736575
  718550
  759566
  536306
  563092
  428854
  714872
  789366
  803725
  725250
  753732
  761219
  612955
  789181
  789374
  731444
  492346
  404602
  484870
  723597
  709204
  720517
  711650
  789350
  455976
  730163
  459215
  728381
  759936
  563083
  807475
  532818
  778853
  728231
  789176
  443173
  453262
  534239
  233029
  561589
  392076
  591281
  454455
  689945
  397210
  397910
  142253
  619070
  188064
  739962
  657776
  614937
  700611
  792523
  428456
  533268
  477444
  720100
  612574
  788142
  793489
  796208
  725213
  747107
  627777
  794403
  444840
  493428
  252068
  728447
  444582
  725570
  737372
  191265
]
3.43 ms
(2.00%)
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
  142253
  188064
  191265
  233029
  252068
  387782
  388155
  391705
  392076
  397210
  397910
  403426
  404602
  416982
  428456
  428854
  430556
  431117
  439785
  443173
  443691
  444582
  444840
  453262
  454455
  455976
  459215
  464890
  466268
  467602
  477097
  477444
  479425
  482496
  484571
  484648
  484870
  485276
  489275
  492346
  493428
  502738
  516090
  517556
  524940
  532818
  533268
  534239
  536306
  539402
  561589
  562832
  562997
  563083
  563092
  573941
  580017
  591054
  591281
  612574
  612955
  614937
  619070
  627777
  657776
  663260
  671356
  675359
  689945
  689983
  700611
  709204
  711650
  714872
  714908
  718550
  720100
  720517
  723597
  725250
  725365
  725570
  725588
  728231
  728381
  728447
  730163
  731444
  736575
  737372
  739962
  744321
  746553
  747107
  753732
  759566
  759936
  761219
  768290
  778853
  788142
  789176
  789181
  789350
  789366
  789374
  792523
  792539
  793489
  794102
  794403
  795299
  796208
  801426
  802074
  803725
  807475
  814865
]
2.24 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boy and mother"
]
2.00 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парен мам женщин"
]
1.75 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парен мам женщин"
]
1.72 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.