Query Metrics
7
Database Queries
7
Different statements
163.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.87 ms (84.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 54378 91344 106389 118098 130482 183404 229233 326290 381901 384238 385478 389479 389788 395547 398105 402630 404693 404884 415249 415313 416417 418558 419058 419888 423245 423554 426772 428724 429001 429508 442216 445974 446510 448717 450584 450994 454163 457283 458543 459283 459746 461151 463809 463937 465250 469041 469047 469048 469976 473169 475707 477038 477498 479190 479703 479707 479710 481259 486261 497235 498462 499243 503235 504326 511733 515932 517173 524322 526564 526836 534627 548573 550787 551029 552933 556289 559194 560673 563625 564808 569668 573256 583640 584539 584674 598670 598726 600956 624745 644128 645980 664302 688274 696978 705464 706929 714666 721414 731759 733176 735602 740595 742105 742698 746222 752550 752722 756521 765917 767506 778549 779704 790972 795307 805044 806045 814644 816591 817743 827117 ] |
||||||||||||||||||||||||||||||
|
15.69 ms (9.59%) |
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 106389 398105 402630 415313 814644 827117 816591 450584 457283 486261 515932 517173 503235 696978 705464 714666 721414 556289 573256 644128 790972 733176 752550 742698 765917 767506 183404 426772 477498 481259 385478 416417 446510 469047 469048 584539 395547 404693 404884 419888 423245 423554 442216 463937 445974 473169 534627 564808 569668 583640 463809 428724 459283 479190 389479 429001 415249 524322 526564 504326 511733 526836 384238 130482 229233 326290 91344 389788 418558 429508 817743 450994 458543 465250 469976 448717 469041 475707 479707 454163 497235 498462 499243 461151 479703 479710 550787 552933 559194 560673 548573 551029 584674 664302 688274 706929 645980 563625 600956 598670 598726 778549 795307 805044 806045 742105 752722 756521 735602 746222 731759 740595 624745 779704 419058 459746 477038 381901 54378 118098 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.91%) |
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 54378 91344 106389 118098 130482 183404 229233 326290 381901 384238 385478 389479 389788 395547 398105 402630 404693 404884 415249 415313 416417 418558 419058 419888 423245 423554 426772 428724 429001 429508 442216 445974 446510 448717 450584 450994 454163 457283 458543 459283 459746 461151 463809 463937 465250 469041 469047 469048 469976 473169 475707 477038 477498 479190 479703 479707 479710 481259 486261 497235 498462 499243 503235 504326 511733 515932 517173 524322 526564 526836 534627 548573 550787 551029 552933 556289 559194 560673 563625 564808 569668 573256 583640 584539 584674 598670 598726 600956 624745 644128 645980 664302 688274 696978 705464 706929 714666 721414 731759 733176 735602 740595 742105 742698 746222 752550 752722 756521 765917 767506 778549 779704 790972 795307 805044 806045 814644 816591 817743 827117 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"man toys"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин toys"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мужчин toys"
]
|
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.