Query Metrics
7
Database Queries
7
Different statements
217.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.36 ms (87.78%) |
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 373995 382014 394700 414337 417389 426259 427539 428425 429609 433204 439020 439158 440094 441073 441081 441131 441952 445413 446274 446797 452577 453137 453400 456226 456229 462384 464905 471674 474044 483348 484816 487191 487779 491114 493398 493679 497509 500734 500787 506149 507542 512543 513746 518083 519699 520910 521182 521792 529617 532727 537476 539470 543714 544108 546955 547496 547778 548186 548836 551550 554803 555286 557203 564303 564755 576221 578349 579185 583712 584029 586594 588379 590564 598310 600358 606081 614957 623078 630096 632605 633134 634071 637115 644402 648540 648699 668387 669034 669062 672275 693194 700990 700993 704208 712782 714562 719957 722022 731772 755150 761321 765632 771600 775693 776277 777847 782789 783368 786920 788185 790409 793534 794759 794859 798999 802597 804230 804351 805661 813396 ] |
||||||||||||||||||||||||||||||
|
16.54 ms (7.59%) |
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 537476 543714 648540 669034 712782 722022 648699 630096 590564 644402 794859 775693 788185 783368 786920 798999 802597 813396 731772 761321 765632 771600 804351 805661 373995 668387 521182 539470 719957 588379 714562 394700 382014 441952 417389 441073 427539 429609 446274 493679 497509 529617 500787 471674 544108 583712 547778 548836 579185 669062 606081 598310 600358 633134 777847 782789 793534 474044 440094 507542 487779 513746 439158 426259 446797 532727 428425 493398 521792 433204 441131 462384 464905 452577 518083 546955 584029 441081 439020 456226 456229 506149 483348 520910 487191 491114 551550 555286 557203 453137 512543 693194 700990 700993 704208 634071 637115 632605 790409 776277 445413 484816 500734 519699 586594 564303 755150 547496 614957 453400 804230 548186 414337 578349 554803 564755 672275 576221 623078 794759 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.27%) |
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 373995 382014 394700 414337 417389 426259 427539 428425 429609 433204 439020 439158 440094 441073 441081 441131 441952 445413 446274 446797 452577 453137 453400 456226 456229 462384 464905 471674 474044 483348 484816 487191 487779 491114 493398 493679 497509 500734 500787 506149 507542 512543 513746 518083 519699 520910 521182 521792 529617 532727 537476 539470 543714 544108 546955 547496 547778 548186 548836 551550 554803 555286 557203 564303 564755 576221 578349 579185 583712 584029 586594 588379 590564 598310 600358 606081 614957 623078 630096 632605 633134 634071 637115 644402 648540 648699 668387 669034 669062 672275 693194 700990 700993 704208 712782 714562 719957 722022 731772 755150 761321 765632 771600 775693 776277 777847 782789 783368 786920 788185 790409 793534 794759 794859 798999 802597 804230 804351 805661 813396 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big hole ass"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие дырк жоп"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.