Query Metrics
7
Database Queries
7
Different statements
147.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.70 ms (83.00%) |
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 21210 55903 197511 256371 266977 280656 383704 385279 397869 401970 408620 448081 457946 461252 465936 476662 523126 529594 530652 531029 534654 535780 536008 537443 540284 554919 556237 559171 560912 575616 577238 580240 583594 588880 589525 589604 591780 600228 600831 602033 604947 615348 616837 617115 625231 628597 631917 633434 634876 635823 636493 646493 650317 652528 652936 670204 697647 700860 701976 703255 707373 708585 725137 740549 744004 750574 751385 752221 752365 753778 754432 754497 754605 756016 757186 764358 767908 768063 772651 774118 776823 777835 779331 780412 781172 782858 785606 786069 786367 793980 800648 801308 801437 801805 803018 803119 803483 803551 804131 805389 805394 807121 808479 812054 812578 814196 814452 819089 819181 819437 819634 821367 821524 822313 825335 825412 826142 827241 827559 ] |
||||||||||||||||||||||||||||||
|
13.96 ms (9.44%) |
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 256371 266977 825335 819634 821524 827241 814196 814452 821367 822313 819089 819437 825412 827559 476662 448081 536008 529594 531029 540284 530652 534654 535780 537443 580240 559171 583594 554919 652936 688185 697647 701976 707373 652528 670204 646493 650317 700860 556237 560912 575616 577238 615348 589525 591780 602033 604947 616837 628597 600831 635823 588880 589604 600228 631917 777835 779331 780412 781172 801308 803483 803551 805389 776823 782858 786069 801437 803119 805394 812578 744004 750574 751385 752221 754432 757186 768063 772651 786367 793980 800648 801805 808479 752365 774118 725137 740549 753778 756016 764358 767908 754605 754497 625231 633434 634876 703255 803018 804131 807121 21210 408620 636493 812054 465936 461252 523126 708585 785606 617115 457946 383704 385279 197511 280656 55903 397869 401970 819181 826142 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.15%) |
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 21210 55903 197511 256371 266977 280656 383704 385279 397869 401970 408620 448081 457946 461252 465936 476662 523126 529594 530652 531029 534654 535780 536008 537443 540284 554919 556237 559171 560912 575616 577238 580240 583594 588880 589525 589604 591780 600228 600831 602033 604947 615348 616837 617115 625231 628597 631917 633434 634876 635823 636493 646493 650317 652528 652936 670204 697647 700860 701976 703255 707373 708585 725137 740549 744004 750574 751385 752221 752365 753778 754432 754497 754605 756016 757186 764358 767908 768063 772651 774118 776823 777835 779331 780412 781172 782858 785606 786069 786367 793980 800648 801308 801437 801805 803018 803119 803483 803551 804131 805389 805394 807121 808479 812054 812578 814196 814452 819089 819181 819437 819634 821367 821524 822313 825335 825412 826142 827241 827559 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot solo"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot соло"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot соло"
]
|
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.