Query Metrics
7
Database Queries
7
Different statements
145.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.97 ms (84.81%) |
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 95562 129902 187592 361978 391386 391756 395614 415936 426416 430389 443218 444684 447808 448832 455886 475836 478572 482605 490261 493521 496792 509800 509879 511254 515934 516375 517847 522910 522913 529597 530039 530624 531236 531260 531824 531836 531840 531861 532804 532839 533382 533556 534981 535358 536288 536305 536339 536419 537913 538817 541849 555071 555126 565154 566688 566698 576684 581302 583460 583496 584001 593808 598648 599847 600249 600289 601636 605337 617428 620663 620794 621656 629963 631162 631178 632641 633150 633521 636299 637042 639752 640534 646152 646849 647939 650175 650459 676092 681547 699695 706232 713298 714122 716745 720072 731877 734469 745326 752621 756472 758304 761530 775024 775946 779560 786120 789961 790962 796285 798948 801536 801923 805990 809468 816882 817113 817176 817377 825044 ] |
||||||||||||||||||||||||||||||
|
13.78 ms (9.51%) |
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 583460 576684 533382 647939 621656 636299 95562 493521 529597 565154 478572 522910 566688 447808 716745 538817 646152 650459 633150 637042 601636 640534 756472 809468 415936 448832 522913 817113 817176 531824 706232 796285 734469 758304 752621 786120 511254 801536 605337 531236 555126 650175 681547 676092 583496 620663 496792 515934 598648 593808 825044 536419 443218 530039 530624 531260 533556 534981 535358 536288 537913 801923 633521 361978 391756 599847 509800 516375 517847 531840 531861 699695 775024 745326 509879 790962 798948 395614 789961 639752 617428 620794 631178 430389 816882 475836 482605 532804 490261 775946 805990 731877 532839 646849 631162 600249 600289 632641 713298 541849 817377 536305 531294 531836 761530 536339 581302 720072 566698 584001 129902 187592 555071 714122 391386 426416 455886 629963 444684 779560 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.49%) |
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 95562 129902 187592 361978 391386 391756 395614 415936 426416 430389 443218 444684 447808 448832 455886 475836 478572 482605 490261 493521 496792 509800 509879 511254 515934 516375 517847 522910 522913 529597 530039 530624 531236 531260 531824 531836 531840 531861 532804 532839 533382 533556 534981 535358 536288 536305 536339 536419 537913 538817 541849 555071 555126 565154 566688 566698 576684 581302 583460 583496 584001 593808 598648 599847 600249 600289 601636 605337 617428 620663 620794 621656 629963 631162 631178 632641 633150 633521 636299 637042 639752 640534 646152 646849 647939 650175 650459 676092 681547 699695 706232 713298 714122 716745 720072 731877 734469 745326 752621 756472 758304 761530 775024 775946 779560 786120 789961 790962 796285 798948 801536 801923 805990 809468 816882 817113 817176 817377 825044 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother double anal"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин double анал"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин double анал"
]
|
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.