Query Metrics
7
Database Queries
7
Different statements
155.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.28 ms (85.06%) |
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 66559 212138 237950 305201 393424 396230 396860 401334 403418 412089 418542 428155 438403 442188 449952 455175 455186 466038 466043 467050 469130 471966 501556 505983 509167 515606 515734 520932 528614 534841 538264 539537 541406 543926 545493 552443 554458 556669 556984 557543 559907 566978 567308 569954 578470 585479 589141 596818 596974 600811 600820 600828 606754 609402 615513 618538 619683 621286 621464 621686 623569 623991 637521 643368 644375 650007 663443 664815 665433 667694 669774 671736 680625 680754 695724 697390 702065 709911 710561 717692 718733 718739 726977 727006 742174 746571 750042 750326 752153 755293 760814 771291 772039 774524 777361 780619 782407 783281 786573 789642 790640 792603 794950 796243 798365 800572 800982 805354 809575 810071 810734 813208 813385 813786 814332 815095 815762 818435 823644 823922 ] |
||||||||||||||||||||||||||||||
|
12.84 ms (8.25%) |
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 621286 396860 455186 396230 818435 815762 515606 538264 539537 528614 543926 585479 606754 621686 805354 774524 792603 796243 742174 810734 237950 471966 466043 823922 823644 814332 665433 671736 663443 717692 589141 809575 813208 783281 810071 755293 777361 412089 467050 438403 515734 212138 428155 442188 505983 541406 556984 718733 650007 664815 697390 702065 709911 596818 600811 800982 771291 727006 637521 813385 403418 520932 534841 554458 559907 578470 667694 680754 556669 596974 623991 789642 794950 726977 752153 750326 772039 623569 393424 449952 305201 615513 800572 66559 545493 669774 600820 619683 643368 790640 750042 746571 401334 813786 455175 501556 718739 680625 557543 644375 609402 786573 760814 710561 782407 469130 418542 466038 815095 509167 566978 567308 569954 695724 552443 600828 621464 618538 798365 780619 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.84%) |
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 66559 212138 237950 305201 393424 396230 396860 401334 403418 412089 418542 428155 438403 442188 449952 455175 455186 466038 466043 467050 469130 471966 501556 505983 509167 515606 515734 520932 528614 534841 538264 539537 541406 543926 545493 552443 554458 556669 556984 557543 559907 566978 567308 569954 578470 585479 589141 596818 596974 600811 600820 600828 606754 609402 615513 618538 619683 621286 621464 621686 623569 623991 637521 643368 644375 650007 663443 664815 665433 667694 669774 671736 680625 680754 695724 697390 702065 709911 710561 717692 718733 718739 726977 727006 742174 746571 750042 750326 752153 755293 760814 771291 772039 774524 777361 780619 782407 783281 786573 789642 790640 792603 794950 796243 798365 800572 800982 805354 809575 810071 810734 813208 813385 813786 814332 815095 815762 818435 823644 823922 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex with boss"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс boss"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс boss"
]
|
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.