Query Metrics
7
Database Queries
7
Different statements
168.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.56 ms (84.43%) |
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 429907 525045 540854 552628 552965 555587 558205 564844 576959 584259 591398 592362 593766 596694 597163 597224 600433 600716 604227 604276 604328 606476 610683 610808 614355 616292 619975 621122 625546 630697 630982 632102 644189 644422 655183 658789 659013 663801 666723 668710 675858 680460 687339 688376 692767 695427 696597 696920 706118 708661 710080 710666 712509 712555 712631 712633 714867 720878 729627 729693 730380 743108 751424 752636 752660 758184 761088 765267 765290 765319 765399 766624 766693 766751 766849 769381 770330 770384 770410 770493 770804 770821 771328 771829 773457 775079 775186 775846 775893 775897 776277 776784 777012 779896 780603 780650 781459 783109 784848 785096 786406 789840 790228 790409 794105 794302 796976 797643 800604 806395 806802 806903 807565 809439 809782 812288 812831 818181 823275 ] |
||||||||||||||||||||||||||||||
|
16.12 ms (9.55%) |
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 758184 765290 771328 773457 770821 614355 597163 796976 765267 730380 712509 695427 596694 775079 781459 630982 790228 429907 666723 775186 807565 729693 766693 770330 630697 552628 668710 564844 812288 584259 658789 663801 706118 644189 752660 632102 776277 600433 604328 552965 789840 555587 680460 591398 525045 797643 775893 540854 761088 616292 712555 783559 806395 770384 775897 806903 785096 625546 710666 604276 818181 675858 720878 775846 809439 783109 712631 655183 619975 800604 806802 809782 794105 743108 771829 558205 823275 659013 712633 688376 710080 610683 765319 766751 766624 770493 644422 606476 776784 779896 604227 784848 621122 765399 766849 687339 692767 780603 812831 752636 770410 696920 729627 592362 610808 770804 751424 576959 593766 600716 708661 714867 769381 696597 597224 780650 777012 786406 790409 794302 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.65%) |
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 429907 525045 540854 552628 552965 555587 558205 564844 576959 584259 591398 592362 593766 596694 597163 597224 600433 600716 604227 604276 604328 606476 610683 610808 614355 616292 619975 621122 625546 630697 630982 632102 644189 644422 655183 658789 659013 663801 666723 668710 675858 680460 687339 688376 692767 695427 696597 696920 706118 708661 710080 710666 712509 712555 712631 712633 714867 720878 729627 729693 730380 743108 751424 752636 752660 758184 761088 765267 765290 765319 765399 766624 766693 766751 766849 769381 770330 770384 770410 770493 770804 770821 771328 771829 773457 775079 775186 775846 775893 775897 776277 776784 777012 779896 780603 780650 781459 783109 784848 785096 786406 789840 790228 790409 794105 794302 796976 797643 800604 806395 806802 806903 807565 809439 809782 812288 812831 818181 823275 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"onlyfans anal fuck"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"онлифанс социальн сет анал секс"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.89%) |
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.