Query Metrics
7
Database Queries
7
Different statements
165.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.21 ms (84.63%) |
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 388724 399255 400903 401142 422557 422959 428012 444935 448927 466936 470839 473112 477258 499866 509473 515101 515207 515220 522587 529298 532153 544708 548064 549289 549377 549933 549994 550623 552534 558002 560375 560480 562100 564000 564681 571219 571481 575514 576380 577515 579668 586465 586582 590250 597052 597072 597965 604068 607215 610657 611933 621288 621436 624216 632835 643653 644078 646208 656761 657325 658631 665123 668894 671598 671644 674400 676942 681699 681848 684342 689311 692386 698044 701309 702624 706899 713526 714441 714822 719716 720786 721447 723439 734850 742209 743063 744612 745999 748675 750465 759326 760222 762718 769786 779860 787950 788805 797915 798329 799008 802596 803183 805197 809705 814128 816503 820650 820993 821120 821184 821373 821418 821423 821836 823000 823309 823326 825467 825499 825781 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (9.39%) |
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 448927 515220 515207 509473 529298 549377 560375 577515 550623 571481 552534 558002 560480 564000 656761 671598 684342 689311 714822 674400 681699 713526 714441 720786 665123 721447 549933 571219 643653 604068 597072 632835 788805 769786 787950 759326 734850 745999 742209 750465 607215 702624 706899 797915 803183 466936 422959 400903 499866 515101 522587 388724 428012 821120 821836 820993 823000 825467 825499 532153 549994 549289 562100 544708 564681 646208 681848 719716 723439 657325 658631 671644 676942 668894 692386 698044 701309 548064 579668 597052 621436 624216 586582 590250 597965 610657 621288 644078 779860 798329 760222 802596 809705 748675 762718 743063 744612 611933 799008 805197 477258 473112 444935 575514 576380 586465 470839 399255 401142 422557 821373 814128 820650 821184 823326 825781 816503 821418 821423 823309 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.63%) |
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 388724 399255 400903 401142 422557 422959 428012 444935 448927 466936 470839 473112 477258 499866 509473 515101 515207 515220 522587 529298 532153 544708 548064 549289 549377 549933 549994 550623 552534 558002 560375 560480 562100 564000 564681 571219 571481 575514 576380 577515 579668 586465 586582 590250 597052 597072 597965 604068 607215 610657 611933 621288 621436 624216 632835 643653 644078 646208 656761 657325 658631 665123 668894 671598 671644 674400 676942 681699 681848 684342 689311 692386 698044 701309 702624 706899 713526 714441 714822 719716 720786 721447 723439 734850 742209 743063 744612 745999 748675 750465 759326 760222 762718 769786 779860 787950 788805 797915 798329 799008 802596 803183 805197 809705 814128 816503 820650 820993 821120 821184 821373 821418 821423 821836 823000 823309 823326 825467 825499 825781 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young skinny fuck"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young худые секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young худые секс"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.86%) |
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.