Query Metrics
7
Database Queries
7
Different statements
386.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.34 ms (54.92%) |
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 33443 39478 50265 118165 195676 198191 214602 223442 381844 383208 384543 384562 386344 386707 389475 389611 392817 396746 396941 396947 397739 398097 402084 402626 403134 404112 407796 414043 414711 415896 416100 416607 429300 443125 447124 454800 457478 460338 466477 473743 474126 476184 481952 501239 502795 503843 507824 529321 533644 544850 578323 583191 588748 594208 600304 610029 610075 622588 627225 634734 634745 640528 648649 653028 670460 671056 685814 694195 694556 705507 709593 712882 716254 718987 728142 736164 738487 739948 741737 744795 744921 746191 749248 752649 758332 770117 771588 772104 783446 788109 790381 790625 792600 793007 794218 794225 794228 794244 794256 794257 796880 800409 801639 801814 802902 803009 804137 807917 811926 812409 817126 818923 821964 822910 825120 825771 826692 827653 827828 827969 ] |
||||||||||||||||||||||||||||||
|
151.91 ms (39.29%) |
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 33443 39478 50265 118165 195676 198191 214602 223442 381844 383208 384543 384562 386344 386707 389475 389611 392817 396746 396941 396947 397739 398097 402084 402626 403134 404112 407796 414043 414711 415896 416100 416607 429300 443125 447124 454800 457478 460338 466477 473743 474126 476184 481952 501239 502795 503843 507824 529321 533644 544850 578323 583191 588748 594208 600304 610029 610075 622588 627225 634734 634745 640528 648649 653028 670460 671056 685814 694195 694556 705507 709593 712882 716254 718987 728142 736164 738487 739948 741737 744795 744921 746191 749248 752649 758332 770117 771588 772104 783446 788109 790381 790625 792600 793007 794218 794225 794228 794244 794256 794257 796880 800409 801639 801814 802902 803009 804137 807917 811926 812409 817126 818923 821964 822910 825120 825771 826692 827653 827828 827969 ] |
||||||||||||||||||||||||||||||
|
14.26 ms (3.69%) |
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 33443 826692 792600 804137 811926 794244 803009 794256 802902 770117 403134 685814 416607 416100 454800 443125 507824 800409 389611 827969 671056 634734 384543 749248 198191 386707 827828 414043 214602 783446 812409 118165 223442 817126 634745 600304 588748 752649 705507 796880 384562 392817 397739 402626 396746 481952 788109 396941 473743 594208 627225 709593 807917 407796 610075 610029 736164 640528 712882 716254 389475 533644 195676 825771 827653 648649 653028 718987 794218 794257 741737 801814 758332 794225 794228 39478 466477 501239 578323 583191 728142 381844 402084 818923 821964 822910 825120 670460 694556 746191 396947 801639 771588 429300 474126 476184 460338 447124 415896 502795 622588 793007 738487 772104 744795 383208 457478 790381 694195 386344 398097 414711 529321 404112 503843 544850 790625 739948 744921 50265 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор натуральные сиськ без силикон"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жёсткое натуральные сиськи"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.49%) |
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.