Query Metrics
7
Database Queries
7
Different statements
183.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.90 ms (86.78%) |
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 409651 410786 426886 432324 432358 455537 457309 461128 463232 467673 472672 478885 479241 486319 490392 490664 492654 495487 496393 498429 499335 504727 507030 507442 508680 510008 514292 520513 523059 525666 528238 531275 533790 534402 535247 536015 536967 537957 538172 539016 540419 540589 542387 546658 547080 547711 548082 551561 551723 552690 552727 553159 554026 554797 556144 556187 556561 556695 557910 558519 558556 558672 560952 561864 562751 564409 564788 565622 567656 568770 568855 573462 575575 577653 578572 580748 581038 581170 582532 583598 587298 587342 590963 591568 592531 593107 593560 594018 594072 594254 596248 598216 602894 603301 604841 605697 606095 606197 606876 607004 621194 623076 627344 630554 632155 634656 646403 654916 655558 656242 656522 668970 669717 678950 680254 684402 697161 727611 749764 781291 ] |
||||||||||||||||||||||||||||||
|
15.19 ms (8.30%) |
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 486319 551561 553159 547080 560952 582532 542387 554797 556187 561864 568770 573462 684402 668970 678950 554026 558519 558556 564409 592531 606095 594254 587298 623076 590963 594072 606197 781291 410786 478885 479241 492654 457309 455537 472672 510008 525666 495487 504727 536967 537957 538172 520513 533790 534402 514292 535247 539016 547711 556144 556561 556695 557910 562751 567656 575575 558672 580748 581038 581170 546658 552690 552727 568855 577653 578572 646403 654916 656242 656522 669717 680254 697161 655558 548082 551723 564788 565622 583598 593107 604841 598216 621194 632155 634656 587342 591568 593560 594018 596248 602894 603301 605697 607004 627344 630554 727611 749764 606876 426886 432358 467673 409651 463232 432324 540419 490392 461128 490664 496393 498429 507030 508680 531275 536015 540589 499335 523059 528238 507442 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.55%) |
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 409651 410786 426886 432324 432358 455537 457309 461128 463232 467673 472672 478885 479241 486319 490392 490664 492654 495487 496393 498429 499335 504727 507030 507442 508680 510008 514292 520513 523059 525666 528238 531275 533790 534402 535247 536015 536967 537957 538172 539016 540419 540589 542387 546658 547080 547711 548082 551561 551723 552690 552727 553159 554026 554797 556144 556187 556561 556695 557910 558519 558556 558672 560952 561864 562751 564409 564788 565622 567656 568770 568855 573462 575575 577653 578572 580748 581038 581170 582532 583598 587298 587342 590963 591568 592531 593107 593560 594018 594072 594254 596248 598216 602894 603301 604841 605697 606095 606197 606876 607004 621194 623076 627344 630554 632155 634656 646403 654916 655558 656242 656522 668970 669717 678950 680254 684402 697161 727611 749764 781291 ] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк телефон"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl telephone"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.77%) |
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.