Query Metrics
7
Database Queries
7
Different statements
199.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.15 ms (84.86%) |
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 37245 95788 95990 96100 96819 130060 181544 326297 328534 382049 386596 387218 388028 388826 396720 396722 397535 397849 399354 404418 405848 417050 417441 420252 420305 423633 426249 429869 430535 436132 443231 444745 445741 446873 448199 449679 458013 460328 461747 464194 468008 468439 468705 472448 476143 478032 478488 480636 485175 485249 490267 503426 512613 516021 519085 519712 521788 524505 527053 532926 532968 533791 533799 533833 535749 540164 540348 543361 547237 556428 576388 581231 582393 585251 591067 591582 592259 592358 594827 597242 599894 599923 600269 604574 611603 611950 615832 619401 621675 621689 622057 627740 630857 637098 639797 646846 649136 649974 650764 651276 660739 668688 676073 679770 702634 704216 704715 712886 715089 716405 721830 732771 756113 779736 802343 811872 814654 814822 824469 825039 ] |
||||||||||||||||||||||||||||||
|
19.53 ms (9.80%) |
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 639797 461747 660739 519085 814822 533791 721830 581231 621689 622057 627740 802343 388028 397535 592259 37245 399354 430535 540164 702634 429869 503426 460328 468008 480636 388826 426249 443231 417050 420252 814654 478488 532968 621675 611603 811872 464194 519712 181544 516021 445741 387218 397849 417441 524505 599894 585251 594827 611950 396722 446873 532926 556428 637098 490267 95788 732771 96819 328534 423633 420305 485249 448199 472448 591067 458013 540348 576388 582393 543361 547237 679770 592358 599923 591582 476143 444745 825039 756113 668688 130060 95990 715089 404418 405848 824469 485175 650764 779736 386596 382049 512613 326297 96100 449679 468439 535749 649136 676073 712886 716405 704715 646846 651276 597242 630857 615832 600269 396720 604574 533799 521788 527053 478032 619401 436132 468705 533833 649974 704216 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.54%) |
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 37245 95788 95990 96100 96819 130060 181544 326297 328534 382049 386596 387218 388028 388826 396720 396722 397535 397849 399354 404418 405848 417050 417441 420252 420305 423633 426249 429869 430535 436132 443231 444745 445741 446873 448199 449679 458013 460328 461747 464194 468008 468439 468705 472448 476143 478032 478488 480636 485175 485249 490267 503426 512613 516021 519085 519712 521788 524505 527053 532926 532968 533791 533799 533833 535749 540164 540348 543361 547237 556428 576388 581231 582393 585251 591067 591582 592259 592358 594827 597242 599894 599923 600269 604574 611603 611950 615832 619401 621675 621689 622057 627740 630857 637098 639797 646846 649136 649974 650764 651276 660739 668688 676073 679770 702634 704216 704715 712886 715089 716405 721830 732771 756113 779736 802343 811872 814654 814822 824469 825039 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big black anal"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие black анал"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие black анал"
]
|
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.