Query Metrics
7
Database Queries
7
Different statements
163.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.15 ms (86.91%) |
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 39142 72519 81658 161969 330409 339285 339374 382792 386695 387722 395990 505795 530584 552929 554875 555197 567590 585283 588922 593747 626664 629686 649771 693176 697994 707583 707734 710763 714282 716774 718224 718893 719191 720563 721740 722049 723521 734103 734421 735534 744223 744327 746506 758412 760442 761258 761259 763603 764620 764695 765802 768587 768661 771778 775159 775583 778477 778810 778942 779442 779952 781488 781516 781546 782340 782897 783682 784381 784426 787661 790127 794519 794535 794586 795559 795769 795801 796344 798061 800026 801919 803439 804075 808201 809758 810161 812434 813634 813936 813937 816680 818736 819300 819313 819382 819451 819728 819790 820202 823255 823876 823935 823947 824080 824092 824522 824701 825306 825861 825892 826006 826236 826470 826627 826748 827367 827481 827709 828215 828229 ] |
||||||||||||||||||||||||||||||
|
12.28 ms (7.51%) |
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 161969 827367 824701 828229 395990 820202 825861 827481 824080 824522 825306 804075 795801 81658 505795 386695 72519 824092 723521 826627 816680 819790 823935 826748 828215 554875 718224 718893 719191 722049 693176 716774 552929 567590 588922 775159 782340 778942 781488 795559 798061 809758 784381 810161 735534 707734 720563 778810 794519 795769 800026 812434 826470 823947 787661 768587 764620 801919 382792 784426 808201 779442 794586 330409 819728 775583 761259 765802 771778 339374 813634 827709 819382 649771 707583 714282 593747 781516 783682 790127 803439 734421 758412 763603 761258 387722 813936 530584 629686 794535 796344 734103 760442 744223 746506 768661 710763 39142 813937 823255 823876 826006 819300 819313 819451 825892 826236 818736 555197 721740 585283 626664 778477 779952 782897 781546 764695 744327 697994 339285 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.62%) |
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 39142 72519 81658 161969 330409 339285 339374 382792 386695 387722 395990 505795 530584 552929 554875 555197 567590 585283 588922 593747 626664 629686 649771 693176 697994 707583 707734 710763 714282 716774 718224 718893 719191 720563 721740 722049 723521 734103 734421 735534 744223 744327 746506 758412 760442 761258 761259 763603 764620 764695 765802 768587 768661 771778 775159 775583 778477 778810 778942 779442 779952 781488 781516 781546 782340 782897 783682 784381 784426 787661 790127 794519 794535 794586 795559 795769 795801 796344 798061 800026 801919 803439 804075 808201 809758 810161 812434 813634 813936 813937 816680 818736 819300 819313 819382 819451 819728 819790 820202 823255 823876 823935 823947 824080 824092 824522 824701 825306 825861 825892 826006 826236 826470 826627 826748 827367 827481 827709 828215 828229 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot sex"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot секс"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot секс"
]
|
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.