Query Metrics
7
Database Queries
7
Different statements
155.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.45 ms (82.53%) |
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 30967 61556 276646 381888 387548 397012 402034 402667 451719 454704 459382 464637 464872 468919 475231 478035 482690 494399 500403 520704 520713 530479 530495 530912 533699 533707 534968 535048 536648 537914 543652 544812 545430 552671 562841 563856 569258 569922 576604 577435 588249 590998 597197 598406 599983 609165 610586 612856 613146 614747 615069 628294 628398 628399 631249 632708 634504 636254 637092 637783 642032 645012 648512 650188 650313 651148 665694 665760 668657 671485 674415 683261 685934 696055 698031 701009 703514 715173 717681 719333 719336 723266 725392 733870 750701 751508 751539 751560 751564 751571 751573 752532 763741 765806 777502 785841 786552 802675 804864 805144 805146 815534 816255 816475 816741 818106 818379 818872 820688 821121 821280 821575 821922 822277 825830 825831 825862 827581 827608 ] |
||||||||||||||||||||||||||||||
|
16.64 ms (10.69%) |
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 725392 482690 576604 763741 520704 588249 597197 719336 610586 786552 631249 535048 562841 750701 805146 459382 544812 805144 569258 628294 598406 824207 545430 628399 534968 719333 632708 683261 733870 650188 613146 674415 645012 612856 537914 563856 651148 628398 569922 609165 827608 530479 520713 599983 637092 715173 61556 825862 816741 536648 577435 820688 543652 614747 642032 530495 530912 821121 650313 402667 818872 827581 821280 696055 665760 276646 648512 397012 818379 802675 752532 751508 30967 685934 821575 671485 723266 816475 765806 381888 533707 822277 751564 464872 818106 703514 533699 668657 387548 464637 478035 701009 637783 698031 751571 751539 751560 751573 785841 402034 825830 816255 634504 717681 500403 454704 665694 590998 615069 636254 451719 821922 475231 468919 494399 815534 825831 804864 777502 552671 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (2.22%) |
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 30967 61556 276646 381888 387548 397012 402034 402667 451719 454704 459382 464637 464872 468919 475231 478035 482690 494399 500403 520704 520713 530479 530495 530912 533699 533707 534968 535048 536648 537914 543652 544812 545430 552671 562841 563856 569258 569922 576604 577435 588249 590998 597197 598406 599983 609165 610586 612856 613146 614747 615069 628294 628398 628399 631249 632708 634504 636254 637092 637783 642032 645012 648512 650188 650313 651148 665694 665760 668657 671485 674415 683261 685934 696055 698031 701009 703514 715173 717681 719333 719336 723266 725392 733870 750701 751508 751539 751560 751564 751571 751573 752532 763741 765806 777502 785841 786552 802675 804864 805144 805146 815534 816255 816475 816741 818106 818379 818872 820688 821121 821280 821575 821922 822277 825830 825831 825862 827581 827608 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fox секс"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fox sex"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fox секс"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.02%) |
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.