Query Metrics
7
Database Queries
7
Different statements
160.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.06 ms (84.30%) |
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 13543 29292 188379 193837 381848 388407 393727 402978 406342 406567 413292 413531 435128 436060 444791 445104 445238 458459 459743 459947 461091 462597 466924 467370 471915 472626 475939 479248 482183 491551 491590 492142 493545 498095 505465 510041 510574 510625 510694 523914 525090 530279 539539 543378 543393 546659 551927 558770 559792 565331 567322 571666 573015 573470 574614 583742 587931 597035 597048 601663 601923 602927 606771 612386 613810 614487 619157 636578 648567 652282 678334 679050 685856 710014 717897 719361 720535 724174 725933 726520 733144 733512 733822 738066 741531 742608 742987 747557 752406 753486 753774 754125 761750 772788 781173 781912 781961 782019 783722 787278 788469 796560 797551 797610 798067 798579 800791 802631 804608 806874 806878 808374 808636 813167 813481 815337 816601 817974 819845 824467 ] |
||||||||||||||||||||||||||||||
|
14.99 ms (9.35%) |
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 458459 471915 491551 413292 819845 710014 783722 798067 747557 813167 733512 752406 753774 406567 459947 614487 719361 796560 583742 602927 726520 797610 402978 479248 445238 491590 393727 467370 435128 741531 193837 817974 493545 530279 652282 678334 806874 813481 742987 733822 772788 782019 808636 459743 797551 510625 510574 444791 816601 543378 685856 717897 606771 587931 781173 753486 761750 601923 436060 815337 679050 413531 461091 804608 381848 824467 466924 498095 567322 573470 559792 543393 565331 613810 733144 612386 475939 601663 787278 788469 445104 802631 808374 781961 462597 482183 539539 546659 648567 571666 619157 636578 597035 800791 806878 742608 725933 558770 525090 388407 406342 574614 551927 781912 472626 505465 510694 523914 720535 798579 754125 724174 13543 29292 510041 573015 738066 188379 492142 597048 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.67%) |
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 13543 29292 188379 193837 381848 388407 393727 402978 406342 406567 413292 413531 435128 436060 444791 445104 445238 458459 459743 459947 461091 462597 466924 467370 471915 472626 475939 479248 482183 491551 491590 492142 493545 498095 505465 510041 510574 510625 510694 523914 525090 530279 539539 543378 543393 546659 551927 558770 559792 565331 567322 571666 573015 573470 574614 583742 587931 597035 597048 601663 601923 602927 606771 612386 613810 614487 619157 636578 648567 652282 678334 679050 685856 710014 717897 719361 720535 724174 725933 726520 733144 733512 733822 738066 741531 742608 742987 747557 752406 753486 753774 754125 761750 772788 781173 781912 781961 782019 783722 787278 788469 796560 797551 797610 798067 798579 800791 802631 804608 806874 806878 808374 808636 813167 813481 815337 816601 817974 819845 824467 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"good blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"good минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"good минет оральн секс"
]
|
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.