Query Metrics
7
Database Queries
7
Different statements
204.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.67 ms (82.85%) |
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 215337 384275 401642 414042 415745 420432 432707 438655 444795 447600 448140 451242 453523 454641 454802 456931 458007 463341 469176 474874 475102 476417 476657 476773 481142 488757 493258 498717 498963 502462 506765 508554 509019 519313 521438 521996 529400 530934 532360 554907 560424 560710 570413 580227 581873 583574 590102 590730 591436 593292 593518 597722 597750 601600 603067 605742 606940 613508 620391 625177 631325 637034 637049 649528 651788 657750 674066 674936 678532 678732 683449 696480 714369 724954 734253 734825 734868 740556 742415 743916 745341 747597 749298 752822 758335 758340 761141 765638 766503 766509 770395 770413 777574 777924 781862 785920 789559 790055 791911 792137 792147 797036 801576 803040 806144 806973 807830 808161 808542 808680 808962 810960 813649 813821 814446 814503 816691 816703 823519 824892 ] |
||||||||||||||||||||||||||||||
|
25.49 ms (12.45%) |
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 613508 814446 560710 651788 678732 777924 806144 808542 743916 752822 631325 463341 593292 447600 448140 498963 603067 625177 493258 384275 414042 508554 456931 770395 420432 519313 451242 469176 797036 734825 432707 813821 814503 816703 453523 583574 714369 649528 606940 593518 781862 791911 806973 740556 808161 765638 401642 476657 554907 657750 801576 734868 745341 761141 581873 637034 498717 454641 580227 674066 570413 803040 747597 770413 521996 597750 590102 637049 474874 813649 823519 674936 696480 591436 808962 724954 758335 790055 792147 807830 488757 476773 475102 521438 529400 590730 597722 601600 476417 444795 454802 438655 816691 530934 683449 560424 620391 777574 808680 734253 758340 766509 810960 766503 742415 785920 789559 509019 506765 502462 824892 792137 749298 215337 605742 458007 415745 481142 532360 678532 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.26%) |
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 215337 384275 401642 414042 415745 420432 432707 438655 444795 447600 448140 451242 453523 454641 454802 456931 458007 463341 469176 474874 475102 476417 476657 476773 481142 488757 493258 498717 498963 502462 506765 508554 509019 519313 521438 521996 529400 530934 532360 554907 560424 560710 570413 580227 581873 583574 590102 590730 591436 593292 593518 597722 597750 601600 603067 605742 606940 613508 620391 625177 631325 637034 637049 649528 651788 657750 674066 674936 678532 678732 683449 696480 714369 724954 734253 734825 734868 740556 742415 743916 745341 747597 749298 752822 758335 758340 761141 765638 766503 766509 770395 770413 777574 777924 781862 785920 789559 790055 791911 792137 792147 797036 801576 803040 806144 806973 807830 808161 808542 808680 808962 810960 813649 813821 814446 814503 816691 816703 823519 824892 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo hot girl"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд hot девушк"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд hot девушк"
]
|
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.