Query Metrics
7
Database Queries
7
Different statements
406.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
215.70 ms (53.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск домашн любительск orgasm"
]
|
||||||||||||||||||||||||||||||
|
167.18 ms (41.11%) |
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 423861 424202 428375 431718 437369 437723 437950 438025 438503 438641 441755 445768 446425 448894 450509 455547 459686 466478 476637 481121 484178 496004 500304 502752 516353 529086 539078 551611 564022 590552 616007 616808 619979 622791 657781 664181 667933 669305 672791 672816 674872 682954 685832 688829 692733 695552 695767 696366 697217 701266 704584 704587 707578 713749 713977 721311 730662 734251 735958 737363 741796 741824 742195 742657 743658 744408 746824 749564 751310 751314 751446 758395 758552 759648 763402 765518 766317 768244 773158 773187 774855 777840 780165 782120 783287 783342 785461 787523 788782 790075 790316 792470 792479 792677 794058 794082 796375 796409 796992 797599 797918 799832 799834 800691 801580 802098 803159 803385 805261 807290 808566 809600 809673 809911 810398 812149 812663 818062 824733 ] |
||||||||||||||||||||||||||||||
|
15.56 ms (3.83%) |
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 797918 730662 737363 735958 766317 768244 783342 788782 792470 797599 801457 809911 812149 685832 438025 438503 818062 481121 455547 445768 438641 551611 707578 669305 682954 695552 696366 697217 704584 619979 704587 423861 502752 701266 564022 674872 672816 431718 743658 428375 672791 667933 780165 790316 777840 742195 758395 765518 785461 794082 800691 751314 751446 742657 744408 746824 749564 758552 773158 751310 721311 437950 466478 437723 446425 529086 616808 539078 448894 741824 424202 824733 500304 713977 792479 794058 799834 801580 805261 808566 774855 790075 796375 796992 802098 807290 812663 773187 799832 803159 803385 759648 763402 741796 782120 783287 787523 792677 796409 809600 809673 810398 496004 441755 437369 459686 450509 476637 590552 484178 516353 692733 695767 657781 664181 688829 713749 616007 622791 734251 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (0.81%) |
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 423861 424202 428375 431718 437369 437723 437950 438025 438503 438641 441755 445768 446425 448894 450509 455547 459686 466478 476637 481121 484178 496004 500304 502752 516353 529086 539078 551611 564022 590552 616007 616808 619979 622791 657781 664181 667933 669305 672791 672816 674872 682954 685832 688829 692733 695552 695767 696366 697217 701266 704584 704587 707578 713749 713977 721311 730662 734251 735958 737363 741796 741824 742195 742657 743658 744408 746824 749564 751310 751314 751446 758395 758552 759648 763402 765518 766317 768244 773158 773187 774855 777840 780165 782120 783287 783342 785461 787523 788782 790075 790316 792470 792479 792677 794058 794082 796375 796409 796992 797599 797918 799832 799834 800691 801580 802098 803159 803385 805261 807290 808566 809600 809673 809911 810398 812149 812663 818062 824733 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian homemade orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск домашн любительск orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.35%) |
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.