Query Metrics
7
Database Queries
7
Different statements
357.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.55 ms (58.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
126.15 ms (35.27%) |
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 393600 419765 437170 449166 450935 454358 458183 458751 476022 476438 482130 485002 488520 495114 495710 503262 504644 504750 505451 506818 511129 512092 512243 512966 513876 514659 518154 532814 542049 542056 542058 542513 542766 544956 548002 567600 576360 578023 578760 591770 594501 594589 594769 602988 603623 605425 605485 605704 621788 626837 628181 628690 630621 632432 633832 635481 636232 636510 638441 648488 648630 649254 653755 653758 653778 654621 654770 659197 661333 661536 661954 662808 663328 666033 666068 672281 674284 675190 679856 695784 695799 704194 704314 705116 714024 716199 716378 716982 717461 718742 723971 725094 729017 730753 730943 731315 732486 732792 733150 733367 733577 734413 738868 738932 742678 748643 748766 755329 760410 761832 773947 779069 783621 788861 795825 795843 795889 796468 800620 802066 ] |
||||||||||||||||||||||||||||||
|
14.82 ms (4.14%) |
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 730943 734413 732792 738932 748766 773947 738868 761832 716199 783621 449166 605485 476438 542056 603623 514659 485002 495710 482130 504750 662808 675190 648630 661536 674284 695784 705116 663328 666068 578760 602988 632432 605704 732486 630621 704314 419765 576360 654770 594769 458751 512966 504644 512243 495114 513876 729017 454358 542766 653758 654621 594589 393600 594501 511129 505451 512092 542513 544956 695799 718742 591770 795889 796468 795825 723971 725094 733367 760410 795843 733577 733150 742678 748643 800620 802066 437170 542049 458183 450935 476022 621788 548002 542058 672281 714024 717461 716378 635481 638441 636232 636510 779069 730753 755329 731315 716982 788861 488520 506818 503262 532814 518154 578023 649254 653755 659197 661333 679856 704194 648488 653778 661954 666033 567600 605425 626837 628181 628690 633832 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (0.77%) |
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 393600 419765 437170 449166 450935 454358 458183 458751 476022 476438 482130 485002 488520 495114 495710 503262 504644 504750 505451 506818 511129 512092 512243 512966 513876 514659 518154 532814 542049 542056 542058 542513 542766 544956 548002 567600 576360 578023 578760 591770 594501 594589 594769 602988 603623 605425 605485 605704 621788 626837 628181 628690 630621 632432 633832 635481 636232 636510 638441 648488 648630 649254 653755 653758 653778 654621 654770 659197 661333 661536 661954 662808 663328 666033 666068 672281 674284 675190 679856 695784 695799 704194 704314 705116 714024 716199 716378 716982 717461 718742 723971 725094 729017 730753 730943 731315 732486 732792 733150 733367 733577 734413 738868 738932 742678 748643 748766 755329 760410 761832 773947 779069 783621 788861 795825 795843 795889 796468 800620 802066 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold amateurs"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд любительск"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.36%) |
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.