Query Metrics
7
Database Queries
7
Different statements
142.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.87 ms (85.09%) |
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 387422 395909 397203 407681 409113 429564 443682 606531 607600 630125 632926 636028 642727 644030 699313 700804 703437 709285 709980 715475 715536 717621 718835 723459 724290 726169 726328 726620 726649 726661 728150 728503 730485 731915 733510 733518 734829 735241 735250 735919 736092 736484 736623 737535 738593 739762 741610 742086 742902 744170 744191 744194 744201 744773 744915 745017 745058 746207 747145 747901 748689 751478 753039 753074 754189 754977 755193 756281 756920 758926 760133 760309 761217 763225 766615 768363 769626 770100 771111 771610 771842 772998 774727 774739 776763 777378 779616 781956 782276 782489 782496 783278 785298 787352 787571 787724 788160 791966 795503 796578 797369 798759 799965 800066 800881 801407 801955 802450 802722 802833 804494 804583 807783 807824 808534 808552 810277 819975 823477 823790 ] |
||||||||||||||||||||||||||||||
|
11.87 ms (8.36%) |
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 798759 799965 800066 802450 802722 741610 742086 744170 744194 744201 745058 753039 756920 760133 761217 782276 782489 783278 785298 787571 787724 791966 796578 797369 800881 801407 801955 808552 810277 726169 726620 728150 733510 736623 737535 738593 744773 746207 754189 754977 758926 760309 770100 771842 772998 726328 726649 726661 728503 733518 734829 735250 736484 744915 745017 747145 768363 724290 730485 731915 735919 739762 742902 747901 748689 751478 755193 763225 771111 735241 736092 753074 756281 766615 769626 771610 606531 607600 630125 632926 636028 642727 644030 699313 700804 703437 709285 709980 715475 715536 717621 718835 723459 774727 774739 776763 777378 779616 781956 782496 787352 788160 795503 802833 804494 804583 807783 807824 808534 409113 395909 387422 407681 443682 397203 429564 819975 744191 823477 823790 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.71%) |
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 387422 395909 397203 407681 409113 429564 443682 606531 607600 630125 632926 636028 642727 644030 699313 700804 703437 709285 709980 715475 715536 717621 718835 723459 724290 726169 726328 726620 726649 726661 728150 728503 730485 731915 733510 733518 734829 735241 735250 735919 736092 736484 736623 737535 738593 739762 741610 742086 742902 744170 744191 744194 744201 744773 744915 745017 745058 746207 747145 747901 748689 751478 753039 753074 754189 754977 755193 756281 756920 758926 760133 760309 761217 763225 766615 768363 769626 770100 771111 771610 771842 772998 774727 774739 776763 777378 779616 781956 782276 782489 782496 783278 785298 787352 787571 787724 788160 791966 795503 796578 797369 798759 799965 800066 800881 801407 801955 802450 802722 802833 804494 804583 807783 807824 808534 808552 810277 819975 823477 823790 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom natural"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom натуральная натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.10%) |
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.