Query Metrics
7
Database Queries
7
Different statements
163.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.81 ms (87.79%) |
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 401476 403117 403147 420072 451677 479871 481052 485235 509500 530388 533101 534145 535476 537394 539941 540939 542440 548205 551051 556611 557887 562215 571171 575409 577463 578869 583395 584093 585339 587479 593995 598952 600150 601820 603966 608808 609977 611409 615615 615697 615884 616060 621575 623115 623647 628152 630303 630473 631180 631386 632232 633036 633041 636191 637586 639169 642689 644029 647317 651081 651322 651332 652092 653571 655559 655561 656202 668285 670067 670213 670255 670569 671439 671534 674295 675584 676734 681963 682820 682926 684536 684806 684817 688937 689207 689235 690751 692135 692606 693157 693559 695097 696304 696475 698484 701303 701909 702862 703450 703972 705372 706193 707197 707367 707878 707964 709046 709242 709751 711161 712955 713767 732144 734036 753693 764826 774803 780214 ] |
||||||||||||||||||||||||||||||
|
9.98 ms (6.09%) |
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 533101 535476 537394 530388 534145 539941 552786 575409 584093 557887 540939 542440 551051 556611 562215 571171 578869 651332 653571 655559 655561 656202 671439 671534 682820 684536 692606 696475 701909 705372 707197 707367 707964 709046 709751 713767 647317 651081 651322 668285 675584 676734 681963 684806 692135 698484 701303 702862 703450 712955 652092 670067 670213 670255 670569 674295 682926 684817 688937 689207 689235 690751 693157 693559 695097 696304 703972 706193 707878 709242 548205 577463 583395 583788 585339 587479 621575 630473 642689 598952 600150 615615 615697 616060 623115 628152 633036 603966 609977 611409 615884 623647 630303 636191 593995 608808 631180 632232 633041 639169 774803 764826 734036 753693 732144 631386 637586 644029 711161 780214 403147 479871 485235 481052 601820 420072 451677 401476 403117 509500 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur beautiful"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.32%) |
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 401476 403117 403147 420072 451677 479871 481052 485235 509500 530388 533101 534145 535476 537394 539941 540939 542440 548205 551051 556611 557887 562215 571171 575409 577463 578869 583395 584093 585339 587479 593995 598952 600150 601820 603966 608808 609977 611409 615615 615697 615884 616060 621575 623115 623647 628152 630303 630473 631180 631386 632232 633036 633041 636191 637586 639169 642689 644029 647317 651081 651322 651332 652092 653571 655559 655561 656202 668285 670067 670213 670255 670569 671439 671534 674295 675584 676734 681963 682820 682926 684536 684806 684817 688937 689207 689235 690751 692135 692606 693157 693559 695097 696304 696475 698484 701303 701909 702862 703450 703972 705372 706193 707197 707367 707878 707964 709046 709242 709751 711161 712955 713767 732144 734036 753693 764826 774803 780214 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск красивая"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.