Query Metrics
7
Database Queries
7
Different statements
170.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.44 ms (85.33%) |
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 185464 339096 397161 417318 418358 418885 420494 420594 422401 424671 425299 428913 429279 433950 435806 439837 443443 449792 451593 452133 456476 456571 456930 457579 461242 464688 464872 465904 466686 469593 470533 475608 475937 478131 480335 481218 481786 493296 493433 497586 497946 504595 512311 520980 521675 523668 526658 527042 528176 543354 555971 556325 557465 559022 564707 564727 567254 567538 571779 572314 573645 573735 573922 575426 578856 585837 586733 588336 589358 590728 594237 600587 605814 626489 636441 643132 659984 660097 672651 673151 691584 693841 703577 720031 729786 740538 747807 765226 768357 768889 772963 773296 774558 774632 777990 779846 782365 782922 783206 785451 785889 786714 789392 789489 790938 791281 797844 805825 807279 809736 810568 811070 814351 815133 817993 818904 821830 823650 ] |
||||||||||||||||||||||||||||||
|
16.15 ms (9.48%) |
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 556325 782922 729786 543354 691584 439837 779846 773296 818904 578856 528176 493296 526658 420594 814351 418358 464688 475608 785889 740538 765226 789489 810568 555971 564707 605814 397161 428913 564727 573922 590728 422401 456930 504595 466686 600587 643132 809736 594237 417318 481786 478131 185464 457579 527042 659984 571779 588336 790938 791281 768889 523668 557465 575426 425299 433950 443443 451593 512311 589358 783206 636441 424671 599432 672651 693841 626489 573645 789392 452133 497586 418885 520980 768357 572314 461242 703577 567254 586733 456571 521675 585837 420494 469593 480335 815133 786714 797844 720031 465904 449792 456476 497946 567538 573735 475937 435806 429279 493433 559022 785451 464872 481218 339096 805825 747807 777990 817993 673151 660097 782365 807279 811070 772963 772838 774558 774632 470533 823650 821830 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.41%) |
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 185464 339096 397161 417318 418358 418885 420494 420594 422401 424671 425299 428913 429279 433950 435806 439837 443443 449792 451593 452133 456476 456571 456930 457579 461242 464688 464872 465904 466686 469593 470533 475608 475937 478131 480335 481218 481786 493296 493433 497586 497946 504595 512311 520980 521675 523668 526658 527042 528176 543354 555971 556325 557465 559022 564707 564727 567254 567538 571779 572314 573645 573735 573922 575426 578856 585837 586733 588336 589358 590728 594237 600587 605814 626489 636441 643132 659984 660097 672651 673151 691584 693841 703577 720031 729786 740538 747807 765226 768357 768889 772963 773296 774558 774632 777990 779846 782365 782922 783206 785451 785889 786714 789392 789489 790938 791281 797844 805825 807279 809736 810568 811070 814351 815133 817993 818904 821830 823650 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful pov blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая пов минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.26 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.