Query Metrics
7
Database Queries
7
Different statements
262.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
239.10 ms (91.13%) |
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 233369 382347 387496 393734 395942 399209 407887 412957 413208 418704 419518 419715 419836 432707 439572 442832 444142 445373 445672 447601 451706 451728 456249 460917 461723 467388 471527 473807 483500 484437 486215 515101 515850 526594 546930 548833 551762 556851 562619 563416 567151 570076 576352 591079 591260 592310 599670 600969 604143 606102 610607 618873 623598 632576 646783 648583 654363 663414 664302 671832 678726 684117 684177 684197 689622 696273 696690 705258 706293 708519 714119 715836 717700 719067 720761 722665 725616 728018 729818 730324 730821 731379 732423 732747 737124 737673 742162 743130 748139 748158 750465 758143 759570 770280 771120 771163 773522 774761 775828 776022 781932 784304 788963 790392 790884 799172 799206 804773 807493 807687 808167 810665 813874 814138 814554 815524 818172 819598 821616 825137 ] |
||||||||||||||||||||||||||||||
|
13.00 ms (4.95%) |
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 730324 732423 748158 759570 728018 732747 737673 750465 770280 623598 775828 776022 807493 808167 444142 515101 399209 696273 706293 646783 730821 771120 407887 233369 387496 814138 722665 663414 618873 395942 825137 563416 678726 717700 684197 725616 731379 771163 799172 393734 720761 781932 799206 460917 412957 814554 818172 451706 546930 548833 719067 689622 551762 576352 606102 592310 599670 591260 810665 729818 671832 705258 418704 442832 445373 813874 815524 451728 456249 484437 684117 714119 715836 632576 784304 804773 758143 807687 610607 432707 419518 447601 419715 467388 515850 526594 486215 742162 445672 567151 788963 773522 556851 790392 562619 591079 419836 819598 821616 664302 684177 696690 604143 774761 382347 413208 654363 737124 748139 743130 708519 790884 473807 483500 461723 570076 471527 648583 600969 439572 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.06%) |
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 233369 382347 387496 393734 395942 399209 407887 412957 413208 418704 419518 419715 419836 432707 439572 442832 444142 445373 445672 447601 451706 451728 456249 460917 461723 467388 471527 473807 483500 484437 486215 515101 515850 526594 546930 548833 551762 556851 562619 563416 567151 570076 576352 591079 591260 592310 599670 600969 604143 606102 610607 618873 623598 632576 646783 648583 654363 663414 664302 671832 678726 684117 684177 684197 689622 696273 696690 705258 706293 708519 714119 715836 717700 719067 720761 722665 725616 728018 729818 730324 730821 731379 732423 732747 737124 737673 742162 743130 748139 748158 750465 758143 759570 770280 771120 771163 773522 774761 775828 776022 781932 784304 788963 790392 790884 799172 799206 804773 807493 807687 808167 810665 813874 814138 814554 815524 818172 819598 821616 825137 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп лиза young"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass lick young"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп лиза young"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.65%) |
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.