Query Metrics
7
Database Queries
7
Different statements
395.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
362.40 ms (91.60%) |
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 392665 397903 397904 398582 409156 409795 415815 416399 418858 423849 427790 428083 434817 436626 436756 438978 440711 440745 440747 440895 441943 443161 443371 445664 446081 446456 456405 457146 458269 458443 459061 459252 460046 461022 461830 463442 466799 471431 474792 474806 474809 478986 482774 482922 484118 490261 492337 492365 502849 504246 504748 507823 512485 512488 513024 514609 523866 548085 558196 563052 571769 579218 580238 590485 595365 599072 600227 600936 601741 602189 602262 603948 604221 605393 606254 611037 613172 620566 623961 627308 630736 643380 647060 648918 657177 657543 658223 658224 658226 660834 662164 662391 674263 679306 691787 693799 694157 700299 713208 718044 720078 736470 738175 744774 749978 750809 751958 759014 762743 776141 784655 786048 790188 794416 795075 795262 798473 799957 806534 814374 ] |
||||||||||||||||||||||||||||||
|
24.23 ms (6.12%) |
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 691787 700299 647060 648918 658224 662164 662391 693799 713208 718044 657177 657543 658223 658226 674263 679306 694157 548085 558196 563052 571769 579218 590485 602189 606254 611037 620566 630736 595365 599072 600227 601741 603948 604221 613172 600936 623961 643380 605393 627308 776141 794416 798473 786048 799957 806534 795075 795262 738175 744774 750809 736470 751958 762743 749978 759014 602262 720078 784655 790188 392665 397903 443161 458269 474792 436626 440711 443371 445664 458443 459252 461830 466799 474806 415815 418858 423849 428083 456405 457146 463442 478986 397904 398582 438978 460046 461022 440895 446081 512485 523866 502849 513024 504748 514609 482922 484118 492337 504246 507823 512488 490261 580238 660834 409156 409795 416399 440747 441943 427790 434817 436756 440745 814374 482774 446456 471431 474809 492365 459061 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (0.61%) |
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 392665 397903 397904 398582 409156 409795 415815 416399 418858 423849 427790 428083 434817 436626 436756 438978 440711 440745 440747 440895 441943 443161 443371 445664 446081 446456 456405 457146 458269 458443 459061 459252 460046 461022 461830 463442 466799 471431 474792 474806 474809 478986 482774 482922 484118 490261 492337 492365 502849 504246 504748 507823 512485 512488 513024 514609 523866 548085 558196 563052 571769 579218 580238 590485 595365 599072 600227 600936 601741 602189 602262 603948 604221 605393 606254 611037 613172 620566 623961 627308 630736 643380 647060 648918 657177 657543 658223 658224 658226 660834 662164 662391 674263 679306 691787 693799 694157 700299 713208 718044 720078 736470 738175 744774 749978 750809 751958 759014 762743 776141 784655 786048 790188 794416 795075 795262 798473 799957 806534 814374 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real webcam"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real вебкамер"
]
|
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.