Query Metrics
7
Database Queries
7
Different statements
421.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.96 ms (51.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen pantyhose 18"
]
|
||||||||||||||||||||||||||||||
|
181.40 ms (43.08%) |
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 20180 25721 338371 386166 393670 413746 416305 420527 422929 425594 432427 432954 433352 434242 441111 441427 443224 445431 447987 450682 452568 452652 460080 462969 465172 469644 470320 470379 470422 471712 478873 479942 483240 498639 508750 510402 511761 512948 513899 523896 525081 529018 529022 535427 536100 542002 550480 552115 571229 595145 599072 603057 614967 616296 624689 633472 633518 634106 634962 636183 637106 640457 644498 648503 651611 659033 665678 689616 689738 694953 700510 710946 715050 720273 721549 735768 740934 743057 747469 751159 752051 752566 755630 758028 758201 758567 758579 761625 764116 766835 771348 772449 776061 776484 777045 777921 784744 785606 785868 786052 787438 788553 788820 790869 792799 796364 796540 799987 800572 804319 805900 806614 806842 806919 808787 813584 814002 814503 815658 821044 ] |
||||||||||||||||||||||||||||||
|
15.42 ms (3.66%) |
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 755630 633472 633518 432954 470320 420527 452652 529022 498639 447987 452568 510402 25721 441427 443224 813584 814503 814002 815658 450682 479942 689738 700510 659033 665678 634962 603057 640457 776061 796540 799987 805900 806614 790869 743057 752051 758567 786052 788820 771348 758028 735768 747469 761625 715050 777921 784744 800572 393670 471712 525081 462969 529018 478873 542002 552115 550480 425594 460080 511761 536100 648503 432427 434242 433352 483240 422929 571229 788553 20180 386166 338371 413746 441111 416305 821044 469644 470422 470379 445431 465172 513899 512948 508750 523896 535427 651611 689616 694953 710946 720273 721549 634106 636183 599072 624689 614967 616296 595145 637106 777045 804319 806919 808787 776484 787438 796364 806842 740934 758579 772449 785606 785868 792799 751159 766835 752566 758201 764116 644498 ] |
||||||||||||||||||||||||||||||
|
4.55 ms (1.08%) |
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 20180 25721 338371 386166 393670 413746 416305 420527 422929 425594 432427 432954 433352 434242 441111 441427 443224 445431 447987 450682 452568 452652 460080 462969 465172 469644 470320 470379 470422 471712 478873 479942 483240 498639 508750 510402 511761 512948 513899 523896 525081 529018 529022 535427 536100 542002 550480 552115 571229 595145 599072 603057 614967 616296 624689 633472 633518 634106 634962 636183 637106 640457 644498 648503 651611 659033 665678 689616 689738 694953 700510 710946 715050 720273 721549 735768 740934 743057 747469 751159 752051 752566 755630 758028 758201 758567 758579 761625 764116 766835 771348 772449 776061 776484 777045 777921 784744 785606 785868 786052 787438 788553 788820 790869 792799 796364 796540 799987 800572 804319 805900 806614 806842 806919 808787 813584 814002 814503 815658 821044 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen pantyhose 18"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen pantyhose 18"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.