Query Metrics
7
Database Queries
7
Different statements
167.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.87 ms (84.19%) |
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 12351 326207 343369 350574 383098 395988 396928 419069 419777 422441 424477 427083 430567 444728 445240 446783 447127 449122 453641 463762 466876 467684 468741 471659 471935 471956 477460 477974 479138 484476 487350 487364 489285 492110 492412 492821 494758 499897 505837 505888 507357 509931 516664 516685 517659 519161 521599 521701 522934 523337 523440 523738 524592 525232 525594 526302 527058 529899 530450 533256 533264 537116 537132 537243 537860 540082 541206 541626 545484 548253 549268 551026 551984 557392 561740 566545 569420 576662 588177 599472 601500 607819 612178 616000 621337 623842 624788 641345 650450 700895 704061 707329 718048 719046 727788 728191 734364 741548 741688 741739 759243 762899 770200 770603 781651 781727 782204 788234 789115 791100 792565 793435 793739 799161 806961 812755 814712 815838 816091 819138 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (9.74%) |
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 422441 492110 383098 12351 588177 759243 607819 446783 541626 430567 814712 492412 516664 569420 621337 789115 424477 523440 529899 395988 350574 396928 815838 819138 507357 517659 624788 782204 788234 762899 792565 707329 445240 449122 343369 444728 484476 526302 537116 540082 537243 566545 700895 719046 601500 793739 727788 453641 419069 499897 551984 548253 612178 623842 479138 471935 816091 492821 494758 704061 599472 616000 812755 471956 447127 468741 516685 524592 509931 466876 519161 477974 487364 523738 525232 525594 527058 463762 427083 467684 419777 505888 522934 487350 541206 326207 471659 477460 489285 505837 521599 533256 537860 523337 537132 521701 530450 533264 549268 576662 557392 561740 718048 650450 545484 551026 641345 781651 781727 806961 793435 799161 770200 770603 791100 741548 728191 734364 741688 741739 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.76%) |
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 12351 326207 343369 350574 383098 395988 396928 419069 419777 422441 424477 427083 430567 444728 445240 446783 447127 449122 453641 463762 466876 467684 468741 471659 471935 471956 477460 477974 479138 484476 487350 487364 489285 492110 492412 492821 494758 499897 505837 505888 507357 509931 516664 516685 517659 519161 521599 521701 522934 523337 523440 523738 524592 525232 525594 526302 527058 529899 530450 533256 533264 537116 537132 537243 537860 540082 541206 541626 545484 548253 549268 551026 551984 557392 561740 566545 569420 576662 588177 599472 601500 607819 612178 616000 621337 623842 624788 641345 650450 700895 704061 707329 718048 719046 727788 728191 734364 741548 741688 741739 759243 762899 770200 770603 781651 781727 782204 788234 789115 791100 792565 793435 793739 799161 806961 812755 814712 815838 816091 819138 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural tits bdsm"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные сиськ без силикон бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.01%) |
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.