Query Metrics
7
Database Queries
7
Different statements
152.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.63 ms (83.47%) |
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 346210 382184 388113 392277 394376 395427 395556 395924 396954 399518 400125 400143 401225 401621 402599 403600 407187 407703 411038 411310 411591 413110 416408 420540 421854 422154 422295 424276 428539 428547 428904 433681 437583 438199 443182 443969 445709 446269 446299 448707 448958 450147 450161 454050 456605 457187 458012 458708 460273 460677 460679 462110 464410 471408 472166 474792 474797 476336 476337 480833 486896 490740 491983 492302 496112 504104 506136 506833 513728 515022 519929 527148 530409 531979 531997 532063 532064 532126 532825 546425 546937 549719 550223 551035 554897 561465 561587 563443 563453 582656 625493 625649 663929 680702 688083 710588 718558 724156 725402 736379 736402 736977 739965 743811 746267 746685 751498 758594 769490 777217 780795 782626 789188 792522 796214 798763 800926 807453 ] |
||||||||||||||||||||||||||||||
|
15.58 ms (10.19%) |
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 510295 546425 625649 782626 769490 751498 697939 401621 413110 420540 438199 471408 394376 403600 563443 400143 416408 437583 519929 513728 392277 388113 401225 411038 458708 454050 464410 492302 515022 532126 532825 527148 531997 532063 490740 549719 561465 561587 582656 625493 789188 807453 777217 780795 792522 798763 800926 736977 796214 725402 746267 758594 736379 739965 428904 457187 395924 395427 395556 399518 400125 428539 433681 443182 680702 445709 446299 448958 450147 460679 486896 458012 460273 476337 506136 462110 546937 554897 550223 663929 710588 688083 718558 736402 746685 724156 743811 422295 474792 448707 424276 450161 346210 474797 480833 491983 421854 422154 382184 407703 428547 446269 472166 496112 504104 563453 411591 456605 506833 460677 396954 402599 411310 407187 443969 530409 531979 532064 476336 551035 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.96%) |
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 346210 382184 388113 392277 394376 395427 395556 395924 396954 399518 400125 400143 401225 401621 402599 403600 407187 407703 411038 411310 411591 413110 416408 420540 421854 422154 422295 424276 428539 428547 428904 433681 437583 438199 443182 443969 445709 446269 446299 448707 448958 450147 450161 454050 456605 457187 458012 458708 460273 460677 460679 462110 464410 471408 472166 474792 474797 476336 476337 480833 486896 490740 491983 492302 496112 504104 506136 506833 513728 515022 519929 527148 530409 531979 531997 532063 532064 532126 532825 546425 546937 549719 550223 551035 554897 561465 561587 563443 563453 582656 625493 625649 663929 680702 688083 710588 718558 724156 725402 736379 736402 736977 739965 743811 746267 746685 751498 758594 769490 777217 780795 782626 789188 792522 796214 798763 800926 807453 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom boy son"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom парен son"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom парен son"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.98%) |
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.