Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.85 ms
(88.44%)
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
  509170
  509231
  510359
  525423
  531044
  531652
  533437
  535250
  535872
  539376
  540120
  542252
  544906
  546237
  546287
  547059
  553183
  553228
  553264
  567661
  576569
  579474
  583565
  584375
  618629
  636354
  646412
  658818
  662064
  678925
  692662
  693748
  698613
  704600
  706015
  713648
  716386
  716476
  813756
  816808
  817306
  817389
  817397
  817421
  817553
  817559
  817601
  817654
  818259
  818285
  819062
  819888
  819912
  819925
  820008
  820312
  823270
  823546
  823547
  823573
  823702
  823703
  823716
  823841
  823966
  824036
  824047
  824222
  824383
  824669
  824758
  824841
  824901
  824910
  824966
  824976
  825049
  825067
  825171
  825211
  825292
  825417
  825775
  825888
  825990
  826268
  826394
  826453
  826496
  826515
  826548
  826596
  826724
  826769
  826819
  826993
  827057
  827240
  827300
  827482
  827568
  828109
  828121
  828150
  828240
  828478
  828563
  828582
  828583
  828608
  828679
  828701
  828720
]
10.71 ms
(5.64%)
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
  816808
  817559
  817654
  819925
  823966
  824222
  824383
  824625
  825049
  825211
  826515
  824976
  826496
  826548
  826596
  826724
  813756
  817389
  817397
  817421
  817601
  818285
  819062
  819912
  820008
  820312
  823573
  823702
  823703
  823742
  824669
  825171
  825990
  826068
  826394
  826769
  826819
  827057
  827240
  827482
  827300
  827568
  817306
  817553
  823270
  823547
  824047
  824287
  824841
  824901
  824910
  824966
  825775
  826268
  826432
  818259
  819888
  823546
  823716
  823811
  823841
  824036
  824758
  825067
  825292
  825353
  825417
  825888
  826453
  828109
  828150
  828240
  828121
  826993
  828608
  828720
  828701
  828583
  828478
  828582
  828679
  828563
  525423
  535872
  531044
  533437
  535250
  540120
  509170
  509231
  531652
  510359
  539376
  544906
  546237
  583565
  542252
  546287
  567661
  584375
  553183
  579474
  658818
  662064
  704600
  706015
  678925
  698613
  713648
  716386
  646412
  692662
  693748
  716476
  547059
  553228
  553264
  576569
  618629
  636354
]
3.03 ms
(1.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
  509170
  509231
  510359
  525423
  531044
  531652
  533437
  535250
  535872
  539376
  540120
  542252
  544906
  546237
  546287
  547059
  553183
  553228
  553264
  567661
  576569
  579474
  583565
  584375
  618629
  636354
  646412
  658818
  662064
  678925
  692662
  693748
  698613
  704600
  706015
  713648
  716386
  716476
  813756
  816808
  817306
  817389
  817397
  817421
  817553
  817559
  817601
  817654
  818259
  818285
  819062
  819888
  819912
  819925
  820008
  820312
  823270
  823546
  823547
  823573
  823702
  823703
  823716
  823841
  823966
  824036
  824047
  824222
  824383
  824669
  824758
  824841
  824901
  824910
  824966
  824976
  825049
  825067
  825171
  825211
  825292
  825417
  825775
  825888
  825990
  826268
  826394
  826453
  826496
  826515
  826548
  826596
  826724
  826769
  826819
  826993
  827057
  827240
  827300
  827482
  827568
  828109
  828121
  828150
  828240
  828478
  828563
  828582
  828583
  828608
  828679
  828701
  828720
]
2.35 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "у замужней женщины"
]
2.08 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен женщин"
]
2.08 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.90%)
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.