Query Metrics
7
Database Queries
7
Different statements
215.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.03 ms (89.50%) |
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 381784 384337 395305 396233 398698 398833 403206 408449 410558 417838 425474 428571 430397 432710 432746 445775 445802 447703 447846 460317 468332 469619 475304 480712 482699 489077 493281 500908 501120 514312 525613 528719 532831 543011 554192 571053 598261 601221 609864 617456 621008 623201 623295 628072 628073 628829 629969 640789 649833 655212 682495 683774 690346 707360 708451 717140 718134 721714 722447 728379 728412 729283 731245 731685 734974 735640 735961 736318 737150 737643 747524 748075 749460 750259 752435 756387 761091 762627 764836 765745 765746 766956 768164 769861 770860 771260 771288 773314 776271 784277 784852 784939 785504 785509 788099 793449 794340 799692 801216 807099 812076 813703 814472 814533 814549 814998 815937 816598 817096 817451 818255 819159 820686 821204 821380 821587 823136 823818 823877 ] |
||||||||||||||||||||||||||||||
|
13.30 ms (6.17%) |
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 815937 819159 821204 823818 690346 718134 617456 623201 609864 621008 801216 812076 736318 785509 788099 794340 799692 728412 761091 731245 765746 766956 770860 762627 765745 410558 818255 814472 814549 813703 655212 721714 708451 722447 601221 623295 628829 776271 784852 725024 737643 747524 752435 737150 769861 771260 734974 756387 773314 728379 735961 717140 785504 425474 445775 396233 475304 493281 554192 628073 432746 432710 395305 428571 430397 817451 482699 408449 398833 403206 445802 571053 640789 628072 447703 381784 814533 820686 821587 816598 823877 814998 525613 543011 683774 707360 729283 748075 750259 764836 793449 731685 771288 735640 749460 768164 807099 501120 489077 649833 528719 532831 821380 384337 629969 398698 447846 460317 598261 469619 480712 417838 468332 514312 500908 817096 823136 682495 784277 784939 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.30%) |
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 381784 384337 395305 396233 398698 398833 403206 408449 410558 417838 425474 428571 430397 432710 432746 445775 445802 447703 447846 460317 468332 469619 475304 480712 482699 489077 493281 500908 501120 514312 525613 528719 532831 543011 554192 571053 598261 601221 609864 617456 621008 623201 623295 628072 628073 628829 629969 640789 649833 655212 682495 683774 690346 707360 708451 717140 718134 721714 722447 728379 728412 729283 731245 731685 734974 735640 735961 736318 737150 737643 747524 748075 749460 750259 752435 756387 761091 762627 764836 765745 765746 766956 768164 769861 770860 771260 771288 773314 776271 784277 784852 784939 785504 785509 788099 793449 794340 799692 801216 807099 812076 813703 814472 814533 814549 814998 815937 816598 817096 817451 818255 819159 820686 821204 821380 821587 823136 823818 823877 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская teen секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina teen sex"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская teen секс"
]
|
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.