Query Metrics
7
Database Queries
7
Different statements
147.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.89 ms (85.18%) |
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 4199 145343 146078 288368 311854 327085 382272 385323 390021 395469 396364 396774 396994 397014 398523 398872 404391 407534 408447 411593 420240 425355 429788 449225 452934 456724 457248 457274 460952 460956 476153 495021 544289 550788 557921 558162 562542 563913 565047 566605 566674 577066 588242 589323 609206 610702 611260 612025 628626 631703 633190 636011 650951 652817 680517 693254 696125 696272 699708 699731 714143 715420 717144 724260 724463 724492 726651 727697 728563 729049 730996 733118 736047 741587 742056 742330 742474 742548 744207 748431 759719 768794 770091 770114 772141 772678 776414 776632 781897 788218 788226 793612 796565 796717 796860 796888 796936 799121 800671 801171 801804 804162 804268 804407 804425 804432 804713 805625 807409 807837 808003 808515 810112 812467 812481 815468 815944 816419 821778 825238 ] |
||||||||||||||||||||||||||||||
|
12.34 ms (8.35%) |
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 796565 804268 805625 808003 724260 770091 781897 788218 804162 808515 724463 724492 744207 741587 759719 727697 768794 772678 628626 636011 699708 776632 796888 804407 804425 812467 390021 588242 327085 398872 404391 411593 457248 396364 385323 288368 821778 449225 452934 457274 565047 566605 566674 680517 800671 807409 772141 799121 408447 407534 396774 456724 4199 460952 460956 476153 146078 652817 396994 420240 815468 815944 816419 544289 563913 650951 714143 696125 696272 577066 611260 631703 589323 609206 612025 610702 801171 796717 742474 742330 699731 796936 382272 397014 311854 398523 633190 736047 558162 715420 730996 804713 729049 145343 495021 395469 425355 825238 557921 812481 429788 562542 693254 550788 810112 793612 728563 788226 801804 804432 807837 742056 726651 733118 742548 770114 748431 717144 776414 796860 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (2.18%) |
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 4199 145343 146078 288368 311854 327085 382272 385323 390021 395469 396364 396774 396994 397014 398523 398872 404391 407534 408447 411593 420240 425355 429788 449225 452934 456724 457248 457274 460952 460956 476153 495021 544289 550788 557921 558162 562542 563913 565047 566605 566674 577066 588242 589323 609206 610702 611260 612025 628626 631703 633190 636011 650951 652817 680517 693254 696125 696272 699708 699731 714143 715420 717144 724260 724463 724492 726651 727697 728563 729049 730996 733118 736047 741587 742056 742330 742474 742548 744207 748431 759719 768794 770091 770114 772141 772678 776414 776632 781897 788218 788226 793612 796565 796717 796860 796888 796936 799121 800671 801171 801804 804162 804268 804407 804425 804432 804713 805625 807409 807837 808003 808515 810112 812467 812481 815468 815944 816419 821778 825238 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy tits"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.01%) |
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.