Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.28 ms
(86.97%)
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
  46788
  353774
  382939
  385138
  385507
  386775
  388620
  401525
  402570
  403049
  405331
  411912
  413316
  420540
  429150
  429830
  431213
  435520
  436646
  437509
  448517
  448709
  450762
  457388
  461742
  467207
  467566
  467638
  468690
  469710
  470625
  471435
  473833
  475576
  477640
  477884
  478343
  478844
  481781
  482564
  483362
  484260
  485476
  487826
  488502
  489612
  490799
  490806
  491570
  492335
  496397
  496848
  501326
  501923
  506876
  508574
  510630
  510642
  511202
  512637
  512644
  517040
  521370
  521712
  523051
  531541
  532050
  532069
  537705
  537727
  538996
  543792
  545524
  547322
  547335
  547344
  549347
  551157
  554635
  556843
  559129
  560574
  564417
  566007
  566857
  567387
  569417
  571852
  571895
  572446
  573777
  574576
  576420
  579322
  584042
  584436
  585526
  595667
  595803
  598344
  615532
  638473
  638570
  655611
  673552
  675801
  699671
  724718
  728286
  771590
  787177
  792888
  793557
  795258
  800409
  802698
  803228
  803984
  804118
  813773
]
12.01 ms
(7.45%)
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
  382939
  429830
  403049
  508574
  470625
  595803
  496397
  569417
  595667
  490806
  388620
  482564
  468690
  487826
  437509
  488502
  402570
  549347
  547322
  436646
  512644
  490799
  467638
  554635
  566007
  429150
  532050
  510630
  385138
  431213
  386775
  353774
  510642
  571895
  435520
  538996
  511202
  556843
  675801
  567387
  537705
  547335
  484260
  475576
  543792
  491570
  673552
  385507
  405331
  448709
  461742
  467566
  469710
  467207
  560574
  572446
  579322
  478343
  448517
  473833
  481781
  477640
  496848
  501326
  787177
  547344
  638473
  802698
  800409
  771590
  793557
  401525
  478844
  532069
  506876
  545524
  576420
  573777
  584436
  585526
  420540
  501923
  489612
  523051
  483362
  485476
  512637
  537727
  551157
  559129
  638570
  795258
  792888
  521712
  584042
  655611
  615532
  803228
  724718
  728286
  699671
  803984
  804118
  450762
  531541
  471435
  571852
  566857
  574576
  564417
  598344
  477884
  411912
  517040
  521370
  492335
  46788
  413316
  813773
  457388
]
2.41 ms
(1.50%)
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
  46788
  353774
  382939
  385138
  385507
  386775
  388620
  401525
  402570
  403049
  405331
  411912
  413316
  420540
  429150
  429830
  431213
  435520
  436646
  437509
  448517
  448709
  450762
  457388
  461742
  467207
  467566
  467638
  468690
  469710
  470625
  471435
  473833
  475576
  477640
  477884
  478343
  478844
  481781
  482564
  483362
  484260
  485476
  487826
  488502
  489612
  490799
  490806
  491570
  492335
  496397
  496848
  501326
  501923
  506876
  508574
  510630
  510642
  511202
  512637
  512644
  517040
  521370
  521712
  523051
  531541
  532050
  532069
  537705
  537727
  538996
  543792
  545524
  547322
  547335
  547344
  549347
  551157
  554635
  556843
  559129
  560574
  564417
  566007
  566857
  567387
  569417
  571852
  571895
  572446
  573777
  574576
  576420
  579322
  584042
  584436
  585526
  595667
  595803
  598344
  615532
  638473
  638570
  655611
  673552
  675801
  699671
  724718
  728286
  771590
  787177
  792888
  793557
  795258
  800409
  802698
  803228
  803984
  804118
  813773
]
1.81 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "поцел сексуальн"
]
1.67 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð┐ð¥ÐåðÁð╗Ðâð© ð© ÐüðÁð║ÐüÐâð░ð╗Ðîð¢Ðïð%ÔǪ"
]
1.58 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.95%)
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.