Query Metrics
7
Database Queries
7
Different statements
373.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.82 ms (56.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy лиза жоп"
]
|
||||||||||||||||||||||||||||||
|
133.16 ms (35.62%) |
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 12411 381749 389347 395938 400579 404117 409822 417560 419221 426006 431147 436510 441955 448042 448053 449181 450370 454855 455438 457803 457956 459752 460856 465471 473474 482573 485008 516534 516975 524693 543246 551602 564369 595950 624520 640476 645224 648471 660649 671837 680611 683428 699166 704584 711327 714927 716247 716911 724602 725491 726582 727510 727531 727545 728932 730806 732220 732236 733282 733329 734397 734664 735544 737207 738066 739938 741073 742983 743047 747566 759693 763963 766282 769448 770607 770981 771426 772425 772440 773336 773550 775591 775600 775650 775653 780297 782456 782760 786122 788201 789066 789531 790383 793218 794165 794453 794485 794736 794991 795017 796473 798095 799988 800846 801604 804494 806090 806233 812053 815698 818546 819995 823754 824372 824414 824845 826455 827300 827577 ] |
||||||||||||||||||||||||||||||
|
18.10 ms (4.84%) |
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 827577 449181 775600 417560 763963 441955 775653 789531 734664 772440 735544 771426 419221 739938 786122 788201 683428 732236 819995 727545 732220 564369 800846 409822 824414 824845 543246 794453 801604 725491 759693 743047 640476 793218 812053 457956 400579 780297 516975 714927 818546 730806 769448 770607 734397 794165 727510 431147 455438 796473 381749 827300 782760 448042 485008 459752 624520 660649 794991 772425 737207 770981 12411 766282 775591 551602 680611 699166 648471 775650 728932 742983 773336 804494 727531 724602 733329 795017 790383 824372 645224 798095 799988 806233 747566 741073 716911 782456 460856 789066 806090 426006 716247 794736 726582 473474 819419 823754 794485 454855 815698 671837 524693 595950 704584 448053 404117 457803 738066 436510 465471 516534 773550 389347 733282 395938 826455 482573 450370 711327 ] |
||||||||||||||||||||||||||||||
|
4.29 ms (1.15%) |
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 12411 381749 389347 395938 400579 404117 409822 417560 419221 426006 431147 436510 441955 448042 448053 449181 450370 454855 455438 457803 457956 459752 460856 465471 473474 482573 485008 516534 516975 524693 543246 551602 564369 595950 624520 640476 645224 648471 660649 671837 680611 683428 699166 704584 711327 714927 716247 716911 724602 725491 726582 727510 727531 727545 728932 730806 732220 732236 733282 733329 734397 734664 735544 737207 738066 739938 741073 742983 743047 747566 759693 763963 766282 769448 770607 770981 771426 772425 772440 773336 773550 775591 775600 775650 775653 780297 782456 782760 786122 788201 789066 789531 790383 793218 794165 794453 794485 794736 794991 795017 796473 798095 799988 800846 801604 804494 806090 806233 812053 815698 818546 819995 823754 824372 824414 824845 826455 827300 827577 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy lick ass"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy лиза жоп"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.47%) |
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.