Query Metrics
7
Database Queries
7
Different statements
171.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.02 ms (84.55%) |
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 384364 384415 386936 388423 391241 391499 400365 418024 423384 432449 432497 434429 442604 451276 452984 453268 455651 457653 464787 465411 467798 468239 470347 474449 474768 476111 478295 478296 478406 484250 486137 502211 503408 506883 506961 517491 519338 523147 524623 528569 539243 539483 547028 551645 555165 557071 558113 562931 563734 583471 583947 593776 593844 594167 594774 595026 602174 603795 605055 606143 608357 609676 610125 619521 619650 626327 627743 629647 658793 662399 664587 666080 669712 674263 678992 680561 682250 686759 692710 700305 707892 710744 710956 713308 715563 721278 721749 722040 722687 725319 726439 727087 727597 734498 735578 736151 739442 740577 747249 748609 749909 755165 756251 756570 758154 759097 760653 761705 764319 772025 782662 784261 787686 794415 794612 796495 800186 811076 813718 824067 ] |
||||||||||||||||||||||||||||||
|
16.02 ms (9.34%) |
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 519338 722687 388423 457653 391499 391241 474768 451276 453268 506961 517491 502211 539243 506883 478296 562931 707892 722040 721278 594167 727597 761705 734498 772025 756570 739442 442604 478406 467798 470347 464787 740577 468239 528569 782662 794415 796495 794612 787686 759097 764319 400365 384364 384415 455651 478295 465411 503408 524623 583471 557071 710956 715563 666080 713308 721749 678992 551645 583947 593844 602174 608357 595026 603795 619521 606143 609676 627743 800186 784261 725319 727087 735578 748609 756251 726439 747249 736151 749909 755165 758154 760653 700305 811076 432497 386936 434429 474449 432449 476111 418024 523147 484250 423384 813718 824067 452984 539483 486137 547028 555165 558113 658793 664587 680561 692710 662399 669712 674263 682250 686759 710744 563734 593776 619650 594774 610125 626327 629647 605055 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.65%) |
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 384364 384415 386936 388423 391241 391499 400365 418024 423384 432449 432497 434429 442604 451276 452984 453268 455651 457653 464787 465411 467798 468239 470347 474449 474768 476111 478295 478296 478406 484250 486137 502211 503408 506883 506961 517491 519338 523147 524623 528569 539243 539483 547028 551645 555165 557071 558113 562931 563734 583471 583947 593776 593844 594167 594774 595026 602174 603795 605055 606143 608357 609676 610125 619521 619650 626327 627743 629647 658793 662399 664587 666080 669712 674263 678992 680561 682250 686759 692710 700305 707892 710744 710956 713308 715563 721278 721749 722040 722687 725319 726439 727087 727597 734498 735578 736151 739442 740577 747249 748609 749909 755165 756251 756570 758154 759097 760653 761705 764319 772025 782662 784261 787686 794415 794612 796495 800186 811076 813718 824067 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot big boobs"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot большие boobs"
]
|
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.