Query Metrics
7
Database Queries
7
Different statements
161.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.07 ms (84.36%) |
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 24855 79601 118226 122488 385690 390360 391108 391554 397445 401601 405690 408432 409934 415777 418054 422277 433380 439758 452297 454274 457449 457473 458623 460659 461717 462010 462931 463695 465270 465540 466227 469034 471164 471608 472670 473949 474132 474265 475968 477927 478806 478904 481124 483629 488414 495250 496726 506866 508698 513641 514205 518763 522094 523636 523833 523867 526526 529236 530003 531533 532746 534683 537135 540799 547423 549829 549848 549851 554992 555086 555108 555119 555138 558700 564286 567683 568991 571103 578734 584771 590613 593083 602959 715368 715572 720105 726595 726602 731254 731836 731913 733097 734373 734730 736196 737598 739927 740991 741023 742585 742749 744968 747958 748395 757388 763547 765391 766650 783145 787580 789160 794420 795731 797178 801254 801450 802132 802195 818349 826127 ] |
||||||||||||||||||||||||||||||
|
14.46 ms (8.96%) |
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 766650 726602 747958 783145 801450 415777 526526 555138 452297 508698 547423 740991 514205 748395 558700 460659 481124 513641 540799 79601 473949 555086 578734 523636 465270 454274 390360 458623 555108 439758 469034 457473 401601 409934 555119 474132 532746 462010 568991 554992 523867 726595 478904 478806 466227 737598 518763 763547 731254 475968 567683 529236 734730 731913 720105 795731 471164 472670 122488 391108 522094 584771 549848 602959 457449 483629 534683 523833 118226 818349 463695 488414 495250 531533 794420 802132 797178 715572 391554 826127 537135 593083 739927 742585 731836 736196 741023 742749 802195 397445 801254 549829 571103 433380 506866 733097 564286 787580 789160 765391 496726 385690 715368 408432 477927 744968 462931 530003 418054 590613 422277 549851 734373 757388 24855 461717 465540 474265 471608 405690 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.81%) |
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 24855 79601 118226 122488 385690 390360 391108 391554 397445 401601 405690 408432 409934 415777 418054 422277 433380 439758 452297 454274 457449 457473 458623 460659 461717 462010 462931 463695 465270 465540 466227 469034 471164 471608 472670 473949 474132 474265 475968 477927 478806 478904 481124 483629 488414 495250 496726 506866 508698 513641 514205 518763 522094 523636 523833 523867 526526 529236 530003 531533 532746 534683 537135 540799 547423 549829 549848 549851 554992 555086 555108 555119 555138 558700 564286 567683 568991 571103 578734 584771 590613 593083 602959 715368 715572 720105 726595 726602 731254 731836 731913 733097 734373 734730 736196 737598 739927 740991 741023 742585 742749 744968 747958 748395 757388 763547 765391 766650 783145 787580 789160 794420 795731 797178 801254 801450 802132 802195 818349 826127 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жену ебут зрелую"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен секс зрелая женщин"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.03%) |
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.