Query Metrics
7
Database Queries
7
Different statements
159.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.29 ms (83.09%) |
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 382419 402896 413544 451946 459867 468721 469069 473505 481173 482679 508236 527689 527988 533601 537698 559602 561771 563522 566971 573938 585668 590190 594955 596692 606417 606684 612188 630479 635138 642659 668401 670111 670190 677133 681134 686035 687505 688106 688567 693256 696165 702050 702947 703437 705120 727451 731623 732562 732938 732953 733029 733128 734728 734730 737066 737089 742709 742902 755388 755464 755466 757071 759580 760763 765147 766698 768420 779663 785361 786510 789502 790387 792608 792754 796219 797009 797664 800110 800541 801465 801609 801646 801839 802101 802450 804477 804494 804583 805015 807930 811085 811428 811493 815173 815256 815397 815462 815484 815518 815768 816083 817312 817323 817443 817718 817852 818123 818133 818281 818333 818402 818422 818495 818822 818882 819054 820875 823563 826349 ] |
||||||||||||||||||||||||||||||
|
15.39 ms (9.67%) |
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 818822 596692 402896 815256 817323 818123 818133 818281 818333 817443 818422 823563 566971 681134 687505 702947 594955 606684 630479 732562 755388 732938 765147 413544 482679 670190 815768 817718 533601 686035 668401 606417 590190 786510 801646 805015 800541 802101 802450 742709 759580 792608 733029 734728 742902 755466 635138 804477 804583 807930 585668 508236 451946 573938 468721 481173 527689 527988 766698 459867 469069 382419 815462 816083 822897 815397 815484 815518 818495 818402 820875 559602 677133 693256 670111 688106 688567 705120 563522 612188 642659 779663 785361 797664 811493 789502 790387 797009 757071 792754 796219 811085 732953 727451 733128 731623 760763 703437 801465 801609 801839 804494 811428 818882 819054 815173 817312 817852 826349 537698 696165 561771 737066 737089 755464 768420 702050 800110 473505 734730 ] |
||||||||||||||||||||||||||||||
|
3.53 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 382419 402896 413544 451946 459867 468721 469069 473505 481173 482679 508236 527689 527988 533601 537698 559602 561771 563522 566971 573938 585668 590190 594955 596692 606417 606684 612188 630479 635138 642659 668401 670111 670190 677133 681134 686035 687505 688106 688567 693256 696165 702050 702947 703437 705120 727451 731623 732562 732938 732953 733029 733128 734728 734730 737066 737089 742709 742902 755388 755464 755466 757071 759580 760763 765147 766698 768420 779663 785361 786510 789502 790387 792608 792754 796219 797009 797664 800110 800541 801465 801609 801646 801839 802101 802450 804477 804494 804583 805015 807930 811085 811428 811493 815173 815256 815397 815462 815484 815518 815768 816083 817312 817323 817443 817718 817852 818123 818133 818281 818333 818402 818422 818495 818822 818882 819054 820875 823563 826349 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милф куннилингус оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"милф кунилингус"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"милф куннилингус оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.19%) |
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.