Query Metrics
7
Database Queries
7
Different statements
356.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.00 ms (58.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза жоп teens"
]
|
||||||||||||||||||||||||||||||
|
123.99 ms (34.74%) |
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 7891 402929 410524 410913 413142 415430 417298 417547 420852 422022 424562 424908 425668 430829 442587 444109 445949 446305 448315 451250 459258 460142 461346 463115 463493 467895 468452 474379 500081 511784 528420 533807 536369 536673 544386 548694 551103 556848 557945 559384 562249 565957 577316 579668 581842 593832 604070 604697 608800 614942 626726 633744 660523 662158 669300 672092 675481 680934 682523 688403 689591 693340 698045 698375 700328 713964 716229 718202 718655 720131 720816 724061 725044 725292 725327 727624 729141 732067 732068 732229 735564 736999 742147 743875 744572 748631 748997 749003 749121 751943 752961 755475 770464 773927 775622 777036 780406 788688 789300 792003 794810 795091 797962 800132 800133 800504 801383 805383 807513 810058 811004 812119 813172 813349 814779 817666 818831 819039 820019 824124 ] |
||||||||||||||||||||||||||||||
|
14.52 ms (4.07%) |
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 813172 7891 724061 402929 413142 817666 820019 818831 819039 460142 680934 713964 672092 675481 693340 662158 700328 604697 795091 801383 812119 813349 777036 788688 794810 800132 800133 810058 749121 751943 773927 792003 797962 811004 725044 725327 748631 749003 727624 743875 736999 770464 775622 789300 669300 732229 444109 814779 536369 556848 716229 718655 807513 742147 415430 424562 467895 417298 500081 528420 593832 425668 410524 410913 468452 533807 511784 626726 805383 752961 614942 780406 445949 424908 430829 463493 536673 544386 548694 551103 557945 422022 474379 718202 725292 577316 824124 451250 633744 461346 732068 417547 420852 442587 446305 459258 463115 448315 581842 562249 559384 720131 660523 688403 698375 682523 689591 720816 565957 579668 604070 744572 748997 755475 800504 735564 729141 732067 608800 698045 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (0.95%) |
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 7891 402929 410524 410913 413142 415430 417298 417547 420852 422022 424562 424908 425668 430829 442587 444109 445949 446305 448315 451250 459258 460142 461346 463115 463493 467895 468452 474379 500081 511784 528420 533807 536369 536673 544386 548694 551103 556848 557945 559384 562249 565957 577316 579668 581842 593832 604070 604697 608800 614942 626726 633744 660523 662158 669300 672092 675481 680934 682523 688403 689591 693340 698045 698375 700328 713964 716229 718202 718655 720131 720816 724061 725044 725292 725327 727624 729141 732067 732068 732229 735564 736999 742147 743875 744572 748631 748997 749003 749121 751943 752961 755475 770464 773927 775622 777036 780406 788688 789300 792003 794810 795091 797962 800132 800133 800504 801383 805383 807513 810058 811004 812119 813172 813349 814779 817666 818831 819039 820019 824124 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick ass teens"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза жоп teens"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.41%) |
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.