Query Metrics
7
Database Queries
7
Different statements
153.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.95 ms (83.49%) |
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 384786 391941 396334 400461 411694 420136 420808 422257 422258 427010 430188 430331 443734 447990 448211 450476 454115 454122 454492 456174 456423 456439 457768 458240 458246 460418 465441 470560 470743 470915 470935 470945 474014 474942 475104 475972 477357 482136 484392 484560 488567 495050 495195 495691 496336 497571 497588 504191 504196 504271 506059 506764 506790 510261 522092 523309 527945 531965 533678 538236 543362 543366 543404 543602 544247 544508 545381 545408 548265 548753 548757 548780 550484 557437 557975 559776 567539 581450 584813 588838 589152 591789 595744 595757 595782 595785 595801 595818 599197 603201 609948 617650 619204 619753 622199 623892 635800 640083 645201 645237 661286 676887 679003 679818 698262 710396 720740 722277 735057 753167 766135 775855 784111 790391 798443 806378 806414 809439 809502 827420 ] |
||||||||||||||||||||||||||||||
|
15.49 ms (10.11%) |
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 506764 522092 482136 545381 543366 545408 645201 645237 698262 609948 622199 588838 595744 619204 595785 595818 784111 806414 809439 809502 766135 710396 806378 422258 454492 475972 458246 470915 420808 422257 430188 506059 484560 510261 679818 531965 543602 544247 679003 595782 753167 548780 567539 548753 720740 623892 477357 391941 474014 495195 497588 384786 550484 599197 400461 457768 557437 396334 411694 430331 827420 456174 470560 458240 533678 495050 460418 543362 581450 543404 544508 557975 559776 676887 661286 722277 548265 548757 584813 591789 619753 589152 595757 595801 603201 635800 775855 798443 735057 640083 470743 470945 474942 427010 454115 470935 450476 456423 448211 456439 465441 443734 504196 538236 504271 527945 504191 506790 523309 488567 475104 495691 484392 420136 447990 790391 617650 496336 497571 454122 ] |
||||||||||||||||||||||||||||||
|
3.63 ms (2.37%) |
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 384786 391941 396334 400461 411694 420136 420808 422257 422258 427010 430188 430331 443734 447990 448211 450476 454115 454122 454492 456174 456423 456439 457768 458240 458246 460418 465441 470560 470743 470915 470935 470945 474014 474942 475104 475972 477357 482136 484392 484560 488567 495050 495195 495691 496336 497571 497588 504191 504196 504271 506059 506764 506790 510261 522092 523309 527945 531965 533678 538236 543362 543366 543404 543602 544247 544508 545381 545408 548265 548753 548757 548780 550484 557437 557975 559776 567539 581450 584813 588838 589152 591789 595744 595757 595782 595785 595801 595818 599197 603201 609948 617650 619204 619753 622199 623892 635800 640083 645201 645237 661286 676887 679003 679818 698262 710396 720740 722277 735057 753167 766135 775855 784111 790391 798443 806378 806414 809439 809502 827420 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade group"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск group"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск group"
]
|
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.