Query Metrics
7
Database Queries
7
Different statements
189.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.03 ms (85.07%) |
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 7981 62175 249637 260940 280073 358566 384016 385491 385946 389863 390813 390922 395433 395639 395661 395707 395720 395733 395824 398164 400166 400169 400550 401673 403464 405527 406983 407089 407148 407505 408306 408437 412363 413889 413904 413993 421340 425633 425800 425834 425945 425957 426025 430241 431022 433656 434624 438001 443802 445500 446278 446624 453149 458327 461599 463171 466075 466959 468774 469288 471008 471941 474029 477080 479100 484416 484485 484660 484695 484703 484718 484738 490923 490933 491078 492108 494731 496540 497953 502512 505023 505693 505811 506580 520473 523803 524351 554004 559386 564648 570700 574596 579938 590627 591294 598911 599610 665207 665284 665288 669736 670489 714864 718836 724133 724328 728288 728452 758617 770196 790015 790022 792663 796078 813913 815417 817413 817463 817917 823622 ] |
||||||||||||||||||||||||||||||
|
17.19 ms (9.08%) |
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 815417 468774 574596 564648 792663 790022 280073 395661 260940 403464 443802 7981 249637 385491 524351 484718 570700 728288 813913 523803 790015 474029 479100 430241 471008 389863 579938 559386 591294 433656 665207 426025 718836 599610 384016 453149 431022 497953 458327 496540 62175 395824 390922 554004 395733 724328 395433 502512 400169 395639 817917 714864 770196 724133 400550 408437 390813 407148 505811 796078 425834 407505 446278 494731 823622 665288 665284 669736 758617 401673 358566 413993 425945 408306 412363 466959 461599 728452 463171 425800 505693 484695 484738 484485 490923 425633 405527 425957 395720 421340 466075 484703 484660 407089 438001 471941 491078 490933 520473 469288 413889 484416 505023 477080 598911 492108 406983 817463 590627 395707 506580 400166 413904 434624 446624 445500 385946 398164 817413 670489 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.62%) |
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 7981 62175 249637 260940 280073 358566 384016 385491 385946 389863 390813 390922 395433 395639 395661 395707 395720 395733 395824 398164 400166 400169 400550 401673 403464 405527 406983 407089 407148 407505 408306 408437 412363 413889 413904 413993 421340 425633 425800 425834 425945 425957 426025 430241 431022 433656 434624 438001 443802 445500 446278 446624 453149 458327 461599 463171 466075 466959 468774 469288 471008 471941 474029 477080 479100 484416 484485 484660 484695 484703 484718 484738 490923 490933 491078 492108 494731 496540 497953 502512 505023 505693 505811 506580 520473 523803 524351 554004 559386 564648 570700 574596 579938 590627 591294 598911 599610 665207 665284 665288 669736 670489 714864 718836 724133 724328 728288 728452 758617 770196 790015 790022 792663 796078 813913 815417 817413 817463 817917 823622 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young boy threesome"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young парен секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young парен секс втро"
]
|
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.