Query Metrics
7
Database Queries
7
Different statements
189.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.33 ms (85.35%) |
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 382677 383255 383652 385790 390493 402538 403187 406861 413346 415525 419106 421129 425684 432794 432802 452149 461120 462787 463905 468577 468692 470788 473057 474622 474707 474719 474760 476372 478426 479856 484134 486726 491198 491512 491516 491590 497140 504335 504461 510146 512883 513657 513798 514293 515945 523330 526547 527995 529054 529060 529076 530470 533516 536674 537233 538355 550128 550411 553489 557522 565070 566077 570722 571211 571218 571229 574815 576271 577328 579325 580512 586449 590961 591660 594613 597255 599872 603381 605309 605316 605322 605328 605330 605333 605334 605347 606846 608386 610283 615618 619477 622025 634527 638533 640602 646428 662994 669085 670412 671918 673445 673763 692270 696225 702624 708840 721187 723098 723532 730107 730278 732160 737088 758540 758557 769401 774163 775943 796920 826070 ] |
||||||||||||||||||||||||||||||
|
17.03 ms (9.01%) |
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 638533 605334 758540 730107 758557 605333 702624 470788 390493 421129 413346 415525 474719 491590 497140 504461 529054 383652 538355 591660 732160 491516 576271 557522 566077 479856 419106 526547 513798 515945 527995 484134 504335 692270 590961 730278 486726 605316 594613 383255 403187 474760 463905 530470 537233 565070 673445 673763 671918 580512 615618 608386 775943 769401 640602 723098 796920 610283 550128 452149 723532 662994 669085 708840 670412 774163 737088 606846 385790 461120 473057 514293 529060 533516 536674 474622 570722 577328 550411 553489 571211 571218 571229 574815 721187 646428 696225 597255 586449 599872 603381 605309 605322 605328 605330 605347 634527 619477 425684 476372 432794 462787 432802 468577 468692 474707 512883 523330 491512 510146 529076 513657 491198 406861 826070 478426 579325 622025 382677 402538 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.61%) |
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 382677 383255 383652 385790 390493 402538 403187 406861 413346 415525 419106 421129 425684 432794 432802 452149 461120 462787 463905 468577 468692 470788 473057 474622 474707 474719 474760 476372 478426 479856 484134 486726 491198 491512 491516 491590 497140 504335 504461 510146 512883 513657 513798 514293 515945 523330 526547 527995 529054 529060 529076 530470 533516 536674 537233 538355 550128 550411 553489 557522 565070 566077 570722 571211 571218 571229 574815 576271 577328 579325 580512 586449 590961 591660 594613 597255 599872 603381 605309 605316 605322 605328 605330 605333 605334 605347 606846 608386 610283 615618 619477 622025 634527 638533 640602 646428 662994 669085 670412 671918 673445 673763 692270 696225 702624 708840 721187 723098 723532 730107 730278 732160 737088 758540 758557 769401 774163 775943 796920 826070 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty casting"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.