Query Metrics
7
Database Queries
7
Different statements
223.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.99 ms (86.86%) |
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 387667 392480 399422 413368 454491 459403 466859 467005 482477 495032 498210 512749 516641 517269 519068 520701 525829 528799 532448 532454 539348 539786 547858 556679 557098 562564 564364 567090 571007 576517 579122 579745 580819 589171 589695 590337 590538 605185 607692 609506 614918 618655 618773 618947 620522 620548 622488 628655 634687 639125 644119 644536 650364 662808 664215 664551 666152 668536 675582 675596 680822 682235 696091 700826 707421 709710 713162 713833 714510 714833 717079 719917 724576 725223 726564 726709 726918 731036 731159 732926 733320 735875 735880 735956 736894 741075 741787 745264 746175 746177 746616 747083 747219 748392 748811 749029 749595 750110 750294 756363 759720 759775 766616 792607 793670 793804 793825 795287 795330 795970 796868 800763 801507 801520 803512 803829 805341 807746 819808 827932 ] |
||||||||||||||||||||||||||||||
|
18.58 ms (8.32%) |
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 516641 495032 580819 650364 696091 719917 700826 713833 717079 664551 564364 639125 605185 618947 793804 795970 805341 726709 746175 736894 726564 747083 741787 746616 725223 726918 749595 644536 714510 801520 528799 714833 609506 803829 748392 512749 520701 387667 399422 413368 827932 525829 532448 482477 547858 556679 576517 662808 668536 675596 579745 620548 628655 590337 590538 803512 747219 793825 733320 759775 746177 749029 731159 732926 796868 800763 466859 539786 571007 589695 766616 519068 392480 819808 454491 532454 539348 567090 579122 557098 664215 666152 675582 682235 707421 562564 618655 589171 620522 644119 618773 622488 795330 807746 793670 801507 731036 750294 756363 735875 735880 745264 759720 724576 750110 735956 741075 748811 634687 713162 792607 467005 498210 517269 614918 459403 680822 607692 795287 709710 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.24%) |
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 387667 392480 399422 413368 454491 459403 466859 467005 482477 495032 498210 512749 516641 517269 519068 520701 525829 528799 532448 532454 539348 539786 547858 556679 557098 562564 564364 567090 571007 576517 579122 579745 580819 589171 589695 590337 590538 605185 607692 609506 614918 618655 618773 618947 620522 620548 622488 628655 634687 639125 644119 644536 650364 662808 664215 664551 666152 668536 675582 675596 680822 682235 696091 700826 707421 709710 713162 713833 714510 714833 717079 719917 724576 725223 726564 726709 726918 731036 731159 732926 733320 735875 735880 735956 736894 741075 741787 745264 746175 746177 746616 747083 747219 748392 748811 749029 749595 750110 750294 756363 759720 759775 766616 792607 793670 793804 793825 795287 795330 795970 796868 800763 801507 801520 803512 803829 805341 807746 819808 827932 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby my девушк"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby my girl"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.41 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby my девушк"
]
|
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.