Query Metrics
7
Database Queries
7
Different statements
202.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.46 ms (86.52%) |
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 401894 408509 408978 411715 413455 414594 423495 439591 448795 450786 454274 455373 457063 461285 461294 462021 466007 466178 466836 467905 469774 473223 475681 479040 482303 484467 484690 484722 486341 490262 490651 493515 495031 495737 506309 509185 517428 517527 524325 525727 527624 544613 544618 545245 545897 546148 552576 555232 555251 555298 555302 555335 555339 555430 555439 555443 558172 563710 566877 569315 574398 578010 578701 580503 585364 589686 590721 591922 592573 592688 609057 614770 614772 614782 614790 614794 622679 680295 696120 707452 710233 710265 713189 714122 714309 714331 714380 714468 714510 714622 714930 717535 722062 725239 725397 730335 735488 754656 761061 768650 788631 790630 791861 796718 797333 802312 802351 803404 803789 804679 807405 807432 807884 812314 812549 819431 824165 826789 827185 827423 ] |
||||||||||||||||||||||||||||||
|
17.26 ms (8.51%) |
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 414594 555335 826789 827185 824165 461285 517527 566877 714930 707452 714331 589686 788631 803404 725397 754656 804679 812549 725239 730335 622679 713189 714122 722062 796718 807432 807884 609057 590721 479040 466007 545245 484722 484467 486341 475681 448795 546148 411715 714309 578010 710265 401894 574398 527624 506309 544613 544618 555232 555302 555430 563710 545897 552576 680295 710233 555251 555339 592688 614770 614794 614772 614790 614782 827423 819431 493515 509185 461294 580503 812314 790630 802312 802351 807405 735488 761061 714510 714622 791861 797333 803789 454274 439591 466836 490262 484690 408509 482303 495737 490651 578701 717535 591922 467905 462021 466178 455373 423495 495031 524325 525727 555298 555443 696120 585364 768650 469774 408978 413455 473223 555439 558172 450786 517428 714380 569315 592573 714468 457063 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.41%) |
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 401894 408509 408978 411715 413455 414594 423495 439591 448795 450786 454274 455373 457063 461285 461294 462021 466007 466178 466836 467905 469774 473223 475681 479040 482303 484467 484690 484722 486341 490262 490651 493515 495031 495737 506309 509185 517428 517527 524325 525727 527624 544613 544618 545245 545897 546148 552576 555232 555251 555298 555302 555335 555339 555430 555439 555443 558172 563710 566877 569315 574398 578010 578701 580503 585364 589686 590721 591922 592573 592688 609057 614770 614772 614782 614790 614794 622679 680295 696120 707452 710233 710265 713189 714122 714309 714331 714380 714468 714510 714622 714930 717535 722062 725239 725397 730335 735488 754656 761061 768650 788631 790630 791861 796718 797333 802312 802351 803404 803789 804679 807405 807432 807884 812314 812549 819431 824165 826789 827185 827423 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy mature homemade"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая mature домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая mature домашн любительск"
]
|
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.