Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
349.50 ms
(91.76%)
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
  285207
  393331
  396697
  400485
  420136
  420600
  428799
  438033
  442527
  443955
  450846
  454672
  456857
  456873
  457685
  457697
  459176
  461671
  470096
  471174
  473268
  473274
  473284
  480707
  484247
  486279
  491695
  496051
  497146
  522547
  528645
  530400
  532719
  534347
  534475
  534667
  535451
  537615
  539641
  540059
  540135
  544610
  545732
  547940
  550477
  550506
  551037
  552278
  552803
  555374
  557267
  559324
  567271
  574508
  574573
  575167
  576277
  577283
  578071
  579768
  580736
  582722
  594458
  606518
  606574
  607235
  607238
  613543
  615997
  633480
  635847
  636528
  649470
  651947
  659388
  660995
  661375
  663931
  664302
  664961
  665134
  668479
  674001
  675456
  695366
  705787
  714440
  738631
  740472
  743446
  747098
  748621
  759591
  763569
  765934
  766387
  772396
  787906
  788866
  793683
  793723
  794033
  794625
  798748
  798825
  799361
  801398
  802011
  803214
  805711
  810500
  810638
  811774
  812526
  814705
  817947
  819649
  825014
]
21.64 ms
(5.68%)
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
  486279
  552803
  577283
  651947
  668479
  695366
  714440
  575167
  635847
  799361
  788866
  793723
  812526
  748621
  802011
  740472
  766387
  772396
  763569
  633480
  787906
  810638
  285207
  473284
  540059
  550477
  442527
  555374
  613543
  473268
  497146
  496051
  559324
  582722
  557267
  606574
  747098
  420136
  450846
  454672
  537615
  534667
  545732
  574573
  660995
  661375
  811774
  793683
  765934
  794033
  794625
  798825
  522547
  461671
  540135
  471174
  470096
  534347
  567271
  607238
  428799
  459176
  491695
  801398
  480707
  400485
  456873
  576277
  574508
  642929
  810500
  457697
  456857
  615997
  473274
  420600
  438033
  528645
  484247
  544610
  393331
  396697
  814705
  819649
  825014
  817947
  530400
  532719
  535451
  534475
  550506
  659388
  664302
  663931
  664961
  665134
  674001
  629530
  594458
  607235
  803214
  798748
  805711
  738631
  743446
  759591
  636528
  443955
  457685
  552278
  606518
  539641
  579768
  547940
  578071
  551037
  580736
  649470
  705787
  675456
]
2.30 ms
(0.60%)
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
  285207
  393331
  396697
  400485
  420136
  420600
  428799
  438033
  442527
  443955
  450846
  454672
  456857
  456873
  457685
  457697
  459176
  461671
  470096
  471174
  473268
  473274
  473284
  480707
  484247
  486279
  491695
  496051
  497146
  522547
  528645
  530400
  532719
  534347
  534475
  534667
  535451
  537615
  539641
  540059
  540135
  544610
  545732
  547940
  550477
  550506
  551037
  552278
  552803
  555374
  557267
  559324
  567271
  574508
  574573
  575167
  576277
  577283
  578071
  579768
  580736
  582722
  594458
  606518
  606574
  607235
  607238
  613543
  615997
  633480
  635847
  636528
  649470
  651947
  659388
  660995
  661375
  663931
  664302
  664961
  665134
  668479
  674001
  675456
  695366
  705787
  714440
  738631
  740472
  743446
  747098
  748621
  759591
  763569
  765934
  766387
  772396
  787906
  788866
  793683
  793723
  794033
  794625
  798748
  798825
  799361
  801398
  802011
  803214
  805711
  810500
  810638
  811774
  812526
  814705
  817947
  819649
  825014
]
2.08 ms
(0.55%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "glasses public"
]
1.76 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "очкастая на улиц"
]
1.65 ms
(0.43%)
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.