Query Metrics
7
Database Queries
7
Different statements
186.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.95 ms (85.24%) |
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 384208 389794 397587 402490 412677 421582 423950 427045 434281 434344 435591 437568 437759 440967 441807 452921 459207 466842 480096 484336 490165 494665 495553 503676 505989 509020 530413 537472 554989 556805 557870 560733 561157 570874 577253 577805 582072 587317 588116 589970 592150 595377 599748 600924 604859 605828 617080 619580 624910 625292 639853 640098 644222 648882 650126 651960 653270 660649 672317 674960 680023 683665 700261 710094 719147 720996 725441 729133 730446 735194 738461 739124 739960 740575 742096 742790 744461 752500 756363 756487 763496 764871 767491 768969 770419 772951 777154 779102 780025 780464 782054 782136 785014 787808 792618 792760 792815 793792 794144 796872 797085 799896 800131 801507 801920 801990 802332 802345 805450 808644 810133 814285 817479 818062 824845 825027 825097 825340 827534 827628 ] |
||||||||||||||||||||||||||||||
|
16.57 ms (8.89%) |
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 752500 725441 437759 452921 494665 384208 397587 402490 427045 814285 817479 824845 825097 827628 818062 825340 827534 825027 459207 530413 503676 505989 490165 577253 650126 653270 660649 700261 648882 651960 674960 680023 710094 683665 719147 720996 557870 561157 570874 587317 588116 592150 600924 604859 625292 595377 605828 617080 640098 644222 777154 793792 797085 780464 782054 785014 799896 800131 801507 801920 805450 808644 756363 782136 792618 792760 794144 810133 735194 739124 744461 729133 730446 739960 763496 738461 742790 767491 768969 740575 764871 770419 772951 779102 780025 787808 792815 796872 801990 802332 802345 423950 412677 437568 441807 495553 509020 480096 440967 484336 466842 537472 560733 582072 577805 672317 554989 556805 599748 619580 639853 589970 624910 742096 756487 421582 434281 389794 434344 435591 ] |
||||||||||||||||||||||||||||||
|
3.92 ms (2.10%) |
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 384208 389794 397587 402490 412677 421582 423950 427045 434281 434344 435591 437568 437759 440967 441807 452921 459207 466842 480096 484336 490165 494665 495553 503676 505989 509020 530413 537472 554989 556805 557870 560733 561157 570874 577253 577805 582072 587317 588116 589970 592150 595377 599748 600924 604859 605828 617080 619580 624910 625292 639853 640098 644222 648882 650126 651960 653270 660649 672317 674960 680023 683665 700261 710094 719147 720996 725441 729133 730446 735194 738461 739124 739960 740575 742096 742790 744461 752500 756363 756487 763496 764871 767491 768969 770419 772951 777154 779102 780025 780464 782054 782136 785014 787808 792618 792760 792815 793792 794144 796872 797085 799896 800131 801507 801920 801990 802332 802345 805450 808644 810133 814285 817479 818062 824845 825027 825097 825340 827534 827628 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"she мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"she мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"she masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.