Query Metrics
7
Database Queries
7
Different statements
191.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.83 ms (87.69%) |
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 188079 386913 399688 404185 404192 405493 502326 546838 556016 556047 561113 562829 566860 583730 587226 599572 600237 600425 606587 628707 631243 631944 638565 641079 641303 644270 644301 644306 647602 650833 651077 656904 670947 671759 672138 672144 672184 673613 682181 682423 683826 685967 686615 692188 702619 703051 703062 703540 705278 708462 709942 713091 716789 717034 717607 718909 720003 720711 720911 721187 721715 724216 741541 742804 743066 746366 748549 755429 756228 756246 756383 770143 770268 770819 770833 770840 770888 775473 775772 777078 778889 784279 784569 788783 789647 789961 790814 799951 801944 802517 802651 802723 804442 804504 805490 805565 805586 805589 805597 805599 807407 809414 809421 809479 810824 813255 815062 815087 815109 815110 815557 815955 816484 816502 817171 817341 817537 817860 820765 825831 ] |
||||||||||||||||||||||||||||||
|
13.00 ms (6.79%) |
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 672184 386913 599572 802651 813255 815062 651077 770143 188079 404185 789961 770268 685967 683826 804504 805586 815087 775473 682423 817171 672144 561113 799951 802517 815955 820765 778889 817341 770840 743066 682181 807407 502326 606587 703051 562829 802723 721187 809421 644306 817860 805597 770888 702619 815109 815110 713091 631944 770833 566860 708462 600425 746366 748549 703540 756246 741541 805565 556047 587226 718909 672138 686615 717607 641303 788783 405493 816484 399688 650833 784569 721715 756383 755429 404192 825831 756228 790814 647602 809414 810824 816502 805589 703062 720911 670947 631243 809479 724216 641079 804442 815557 817537 583730 705278 673613 805599 709942 716789 805490 784279 638565 692188 742804 600237 644270 770819 628707 671759 801944 546838 556016 789647 720711 777078 720003 644301 717034 775772 656904 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.39%) |
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 188079 386913 399688 404185 404192 405493 502326 546838 556016 556047 561113 562829 566860 583730 587226 599572 600237 600425 606587 628707 631243 631944 638565 641079 641303 644270 644301 644306 647602 650833 651077 656904 670947 671759 672138 672144 672184 673613 682181 682423 683826 685967 686615 692188 702619 703051 703062 703540 705278 708462 709942 713091 716789 717034 717607 718909 720003 720711 720911 721187 721715 724216 741541 742804 743066 746366 748549 755429 756228 756246 756383 770143 770268 770819 770833 770840 770888 775473 775772 777078 778889 784279 784569 788783 789647 789961 790814 799951 801944 802517 802651 802723 804442 804504 805490 805565 805586 805589 805597 805599 807407 809414 809421 809479 810824 813255 815062 815087 815109 815110 815557 815955 816484 816502 817171 817341 817537 817860 820765 825831 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom anal threesome"
]
|
||||||||||||||||||||||||||||||
|
2.34 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom анал секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom анал секс втро"
]
|
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.