Query Metrics
7
Database Queries
7
Different statements
405.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
377.62 ms (93.17%) |
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 56464 107545 153472 161969 193837 338258 338311 366354 382802 384778 386879 387195 389730 390574 391054 391163 392028 394785 395148 395522 398946 406579 407683 409887 423771 424910 425630 440979 448671 451456 460190 464240 465434 468183 468750 471627 471963 475629 484063 492001 493170 496607 496625 531066 534454 540351 540691 543288 553841 563445 575177 577138 579163 580270 589687 591279 591283 597604 601925 606640 616679 618344 618960 621716 624691 627052 632929 633050 643097 649919 658468 664285 665478 669747 676121 682181 687555 702237 703141 706007 712335 715459 717948 721674 725355 725826 726538 730225 734572 734903 741859 744922 744968 746000 749861 754680 755087 755140 755322 756452 758185 759484 759975 764456 770061 774141 775800 784776 790238 790640 795147 795835 796278 796759 797355 800684 801344 803437 809941 810062 ] |
||||||||||||||||||||||||||||||
|
17.76 ms (4.38%) |
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 161969 801344 56464 721674 649919 591279 643097 597604 790238 755087 755322 754680 774141 391054 759975 338311 715459 758185 734572 484063 665478 746000 627052 712335 725355 759484 730225 800684 755140 632929 797355 810062 703141 394785 618960 775800 471963 795147 386879 543288 601925 741859 749861 440979 409887 392028 389730 664285 382802 107545 424910 496625 658468 764456 770061 540351 553841 744922 624691 460190 395148 425630 563445 717948 579163 423771 384778 398946 391163 621716 702237 616679 338258 451456 580270 496607 468183 193837 465434 540691 534454 687555 669747 606640 796759 803437 756452 725826 809941 448671 790640 706007 633050 796278 795835 734903 575177 618344 744968 407683 366354 390574 475629 464240 387195 406579 493170 531066 153472 676121 577138 589687 591283 682181 395522 468750 784776 726538 471627 492001 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (0.76%) |
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 56464 107545 153472 161969 193837 338258 338311 366354 382802 384778 386879 387195 389730 390574 391054 391163 392028 394785 395148 395522 398946 406579 407683 409887 423771 424910 425630 440979 448671 451456 460190 464240 465434 468183 468750 471627 471963 475629 484063 492001 493170 496607 496625 531066 534454 540351 540691 543288 553841 563445 575177 577138 579163 580270 589687 591279 591283 597604 601925 606640 616679 618344 618960 621716 624691 627052 632929 633050 643097 649919 658468 664285 665478 669747 676121 682181 687555 702237 703141 706007 712335 715459 717948 721674 725355 725826 726538 730225 734572 734903 741859 744922 744968 746000 749861 754680 755087 755140 755322 756452 758185 759484 759975 764456 770061 774141 775800 784776 790238 790640 795147 795835 796278 796759 797355 800684 801344 803437 809941 810062 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мамка соблазняет"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин соблазня"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.38%) |
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.