Query Metrics
7
Database Queries
7
Different statements
195.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.54 ms (87.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 391873 457698 459525 463232 467673 473711 475053 478413 478569 483902 488517 493776 494528 502260 503721 505109 506639 507921 509113 510008 510058 514292 517542 521522 524942 525666 526465 526959 530722 533790 534722 534877 534880 536201 537359 537757 537800 537957 539685 540036 540888 541344 548082 551561 554626 556167 556185 556998 558652 559329 562385 562751 563715 567947 576201 581502 583456 585326 587080 589212 590470 591395 591446 591710 591748 592275 593010 593858 594072 595083 595103 595236 596943 597634 597786 598469 603389 603664 606506 606858 606894 610589 615177 616581 616643 616674 617848 618046 618249 618527 620847 624907 626345 626773 627540 627578 628259 630036 630648 630849 630984 631292 631695 631719 632780 633316 633992 634029 634686 635665 637959 638040 639018 639951 641806 641897 716841 727611 731239 ] |
||||||||||||||||||||||||||||||
|
14.13 ms (7.24%) |
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 610589 624907 626773 628935 630648 630849 631695 634029 635665 639951 585326 587080 591710 591748 593010 595083 595103 598469 603389 603664 606506 620847 626345 628259 631719 633992 589212 590470 592275 593858 594072 595236 596943 597634 597786 616581 616674 617848 618249 618527 627540 630984 633316 637959 639018 641806 641897 731239 606858 606894 615177 618046 627578 630036 631292 632780 634686 638040 506639 521522 505109 502260 537359 576201 581502 457698 473711 488517 459525 478569 493776 510008 525666 534877 507921 537957 494528 533790 514292 526959 562751 556185 558652 563715 548082 556167 556998 591395 591446 616643 727611 716841 467673 391873 463232 475053 509113 503721 526465 540888 483902 478413 534722 540036 510058 537757 517542 530722 534880 537800 539685 524942 536201 551561 554626 559329 562385 567947 583456 541344 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.51%) |
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 391873 457698 459525 463232 467673 473711 475053 478413 478569 483902 488517 493776 494528 502260 503721 505109 506639 507921 509113 510008 510058 514292 517542 521522 524942 525666 526465 526959 530722 533790 534722 534877 534880 536201 537359 537757 537800 537957 539685 540036 540888 541344 548082 551561 554626 556167 556185 556998 558652 559329 562385 562751 563715 567947 576201 581502 583456 585326 587080 589212 590470 591395 591446 591710 591748 592275 593010 593858 594072 595083 595103 595236 596943 597634 597786 598469 603389 603664 606506 606858 606894 610589 615177 616581 616643 616674 617848 618046 618249 618527 620847 624907 626345 626773 627540 627578 628259 630036 630648 630849 630984 631292 631695 631719 632780 633316 633992 634029 634686 635665 637959 638040 639018 639951 641806 641897 716841 727611 731239 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade mobile"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск телефон"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.88%) |
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.