Query Metrics
7
Database Queries
7
Different statements
177.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.81 ms (86.42%) |
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 51569 357499 362712 383785 391994 405816 410683 418519 428919 439520 450268 458684 476191 477430 481961 491777 494809 500905 507057 507643 510844 515675 518199 523607 528596 529394 531033 534082 536467 537167 547464 547927 547979 553277 554407 555039 555786 555977 560343 574257 576597 582339 587184 589697 592539 593398 595438 596011 598375 599238 599814 600223 603390 606134 607534 613610 614361 614829 618985 619100 620647 628113 629742 629806 632094 643373 660380 669022 669023 694098 708541 710308 710559 714386 715472 715473 720514 720622 722388 726946 733458 733541 740553 740555 741716 742315 748690 749019 749087 750900 751019 754436 761039 770122 770231 772554 772578 776827 781922 787329 788753 794647 796803 798087 799168 799640 799644 801764 802742 803106 803507 806793 811104 811604 817575 818532 819235 819237 823607 824632 ] |
||||||||||||||||||||||||||||||
|
14.37 ms (8.07%) |
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 439520 507643 362712 51569 817575 531033 536467 547979 715472 720514 592539 613610 593398 599814 776827 787329 799644 803507 811104 799168 733458 749019 740555 632094 708541 811604 643373 819237 669022 714386 799640 794647 772578 798087 715473 761039 818532 823607 534082 582339 553277 560343 660380 710308 628113 620647 802742 801764 748690 726946 742315 754436 607534 614829 722388 803106 523607 510844 694098 806793 749087 589697 555786 383785 547927 555977 598375 494809 500905 477430 529394 507057 554407 629742 603390 772554 391994 410683 357499 428919 458684 481961 450268 476191 418519 518199 555039 405816 537167 515675 574257 528596 491777 819235 547464 720622 669023 587184 629806 741716 733541 751019 710559 781922 824632 576597 606134 614361 595438 618985 600223 596011 599238 619100 788753 740553 770231 796803 770122 750900 ] |
||||||||||||||||||||||||||||||
|
3.14 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 51569 357499 362712 383785 391994 405816 410683 418519 428919 439520 450268 458684 476191 477430 481961 491777 494809 500905 507057 507643 510844 515675 518199 523607 528596 529394 531033 534082 536467 537167 547464 547927 547979 553277 554407 555039 555786 555977 560343 574257 576597 582339 587184 589697 592539 593398 595438 596011 598375 599238 599814 600223 603390 606134 607534 613610 614361 614829 618985 619100 620647 628113 629742 629806 632094 643373 660380 669022 669023 694098 708541 710308 710559 714386 715472 715473 720514 720622 722388 726946 733458 733541 740553 740555 741716 742315 748690 749019 749087 750900 751019 754436 761039 770122 770231 772554 772578 776827 781922 787329 788753 794647 796803 798087 799168 799640 799644 801764 802742 803106 803507 806793 811104 811604 817575 818532 819235 819237 823607 824632 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature stockings solo"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature чулк нижн бел соло"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.33 ms (0.74%) |
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.