Query Metrics
7
Database Queries
7
Different statements
152.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.37 ms (83.96%) |
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 4497 234600 381813 381942 398543 420166 452025 452940 455475 460017 467114 471111 475637 477227 479085 490389 491099 491125 506765 514827 518598 526747 526837 532872 535317 535364 537087 537134 548010 549740 553130 554324 554488 558157 575983 587184 588230 599489 601122 605155 605208 614358 617654 619593 619628 629595 629978 633190 636431 636586 640312 645921 645928 664594 665586 667011 668563 672369 693254 706889 709241 710379 714698 720524 720540 720622 733541 736036 737524 741691 741713 741716 741764 741770 742321 742359 742706 744185 744186 744204 746122 750412 751678 752844 753667 755354 755369 759793 761191 770099 772578 776452 776455 776736 781922 781925 788568 796808 796816 798087 798753 799640 800508 801804 803835 804259 804432 804443 809517 809650 811871 812379 812512 817873 819237 819239 819254 823589 824502 826600 ] |
||||||||||||||||||||||||||||||
|
15.80 ms (10.34%) |
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 398543 819237 471111 535317 548010 645928 693254 633190 799640 800508 812379 744204 798087 801804 804432 741691 742706 809517 491125 826600 761191 709241 665586 587184 741770 746122 733541 798753 755354 452940 809650 601122 636586 788568 535364 720524 629978 811871 744186 776736 812512 759793 781922 720540 532872 553130 605208 772578 755369 803835 420166 741764 575983 460017 549740 706889 667011 672369 714698 720622 636431 599489 804259 741716 751678 796808 477227 479085 526747 514827 558157 234600 752844 753667 817873 824502 819254 819239 537087 770099 664594 796816 781925 381942 823589 491099 640312 605155 804443 741713 736036 742321 744185 710379 588230 475637 4497 737524 776452 381813 518598 490389 554488 619593 750412 742359 455475 452025 526837 506765 467114 554324 537134 645921 668563 629595 619628 614358 617654 776455 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.62%) |
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 4497 234600 381813 381942 398543 420166 452025 452940 455475 460017 467114 471111 475637 477227 479085 490389 491099 491125 506765 514827 518598 526747 526837 532872 535317 535364 537087 537134 548010 549740 553130 554324 554488 558157 575983 587184 588230 599489 601122 605155 605208 614358 617654 619593 619628 629595 629978 633190 636431 636586 640312 645921 645928 664594 665586 667011 668563 672369 693254 706889 709241 710379 714698 720524 720540 720622 733541 736036 737524 741691 741713 741716 741764 741770 742321 742359 742706 744185 744186 744204 746122 750412 751678 752844 753667 755354 755369 759793 761191 770099 772578 776452 776455 776736 781922 781925 788568 796808 796816 798087 798753 799640 800508 801804 803835 804259 804432 804443 809517 809650 811871 812379 812512 817873 819237 819239 819254 823589 824502 826600 ] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло mature большие"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло mature большие"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo mature big"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.94%) |
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.