Query Metrics
7
Database Queries
7
Different statements
216.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.12 ms (80.31%) |
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 411737 422192 428103 428224 436942 439801 441853 442128 445617 445641 448714 452293 454264 454954 456293 456516 463842 463976 464139 464328 465312 466885 466982 466989 467611 467972 468630 468910 469534 473391 475684 475828 475869 484727 485454 490262 491802 491823 493210 494833 494985 495051 506081 506801 507651 508518 508523 511313 511596 512447 513025 513775 514070 515723 516744 517604 517881 519853 522556 524882 525026 525864 526052 527451 528361 529213 529485 531511 535460 537970 538848 541588 541611 541633 541665 541683 541871 549225 549233 549239 558490 559127 559132 566374 573393 575198 576710 576723 577392 579341 583701 584352 593372 601324 604429 605521 610695 612434 614737 615382 630063 639824 641978 642016 643103 646901 649953 650380 676117 688116 714346 714479 731158 756395 788776 814903 ] |
||||||||||||||||||||||||||||||
|
31.34 ms (14.46%) |
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 511313 529213 643103 475828 484727 731158 593372 468630 508518 579341 583701 649953 527451 428224 507651 541665 524882 517881 467611 541633 646901 714479 411737 456293 814903 454954 466982 493210 639824 756395 516744 535460 525864 558490 610695 494985 508523 573393 469534 522556 537970 575198 676117 456516 517604 475869 688116 714346 630063 448714 436942 491802 531511 506801 549233 576723 650380 576710 463842 464139 612434 526052 466885 513025 788776 468910 495051 422192 445617 485454 515723 538848 525026 428103 541683 614737 642016 445641 512447 541871 464328 475684 494833 566374 442128 528361 601324 605521 513775 491823 465312 615382 441853 439801 541588 641978 541611 559127 514070 473391 584352 454264 519853 549239 466989 577392 490262 506081 467972 529485 511596 549225 559132 452293 463976 604429 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (1.69%) |
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 411737 422192 428103 428224 436942 439801 441853 442128 445617 445641 448714 452293 454264 454954 456293 456516 463842 463976 464139 464328 465312 466885 466982 466989 467611 467972 468630 468910 469534 473391 475684 475828 475869 484727 485454 490262 491802 491823 493210 494833 494985 495051 506081 506801 507651 508518 508523 511313 511596 512447 513025 513775 514070 515723 516744 517604 517881 519853 522556 524882 525026 525864 526052 527451 528361 529213 529485 531511 535460 537970 538848 541588 541611 541633 541665 541683 541871 549225 549233 549239 558490 559127 559132 566374 573393 575198 576710 576723 577392 579341 583701 584352 593372 601324 604429 605521 610695 612434 614737 615382 630063 639824 641978 642016 643103 646901 649953 650380 676117 688116 714346 714479 731158 756395 788776 814903 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal saggy hairy"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал saggy волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал saggy волосатая"
]
|
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.