Query Metrics
7
Database Queries
7
Different statements
159.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.66 ms (83.58%) |
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 47613 123994 308783 365938 382381 386197 389318 390875 391941 396595 398022 399415 400461 402015 409532 411947 416958 417827 422257 422258 424406 427010 430188 430325 430331 444852 448211 448913 450476 454367 456859 457764 460418 465441 470572 470743 470918 471771 471974 474014 476419 478439 482136 484857 495050 498205 501267 504271 506790 510261 510480 527945 533678 540896 543362 543418 543590 544671 544959 548265 548753 548756 548757 548780 551032 551038 551242 552251 557437 557975 557978 558450 562364 562369 578717 581450 585281 589152 591327 595785 603236 603891 605334 614262 622199 623892 625736 631908 640083 648924 651489 661286 667757 668380 670717 676887 677881 686073 687639 690851 692419 703538 707557 710396 718788 720740 722277 723892 731356 742214 752569 766096 766129 768581 775758 775855 806378 809502 810466 827420 ] |
||||||||||||||||||||||||||||||
|
17.07 ms (10.67%) |
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 482136 622199 809502 710396 806378 411947 422258 430188 510261 548756 631908 474014 544959 495050 723892 768581 386197 365938 558450 551242 775758 417827 692419 648924 548780 548753 623892 391941 308783 557975 670717 589152 591327 731356 416958 506790 400461 552251 562369 614262 742214 47613 382381 470572 543418 471771 448913 430325 543590 687639 544671 595785 422257 444852 578717 430331 533678 543362 581450 676887 718788 668380 625736 603236 640083 470743 427010 504271 123994 396595 703538 409532 557437 562364 456859 667757 766129 720740 677881 707557 690851 752569 390875 540896 484857 389318 398022 399415 510480 686073 827420 460418 557978 661286 722277 548265 548757 551038 603891 775855 476419 470918 450476 448211 465441 527945 424406 454367 471974 810466 478439 501267 551032 651489 585281 766096 498205 402015 457764 605334 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.73%) |
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 47613 123994 308783 365938 382381 386197 389318 390875 391941 396595 398022 399415 400461 402015 409532 411947 416958 417827 422257 422258 424406 427010 430188 430325 430331 444852 448211 448913 450476 454367 456859 457764 460418 465441 470572 470743 470918 471771 471974 474014 476419 478439 482136 484857 495050 498205 501267 504271 506790 510261 510480 527945 533678 540896 543362 543418 543590 544671 544959 548265 548753 548756 548757 548780 551032 551038 551242 552251 557437 557975 557978 558450 562364 562369 578717 581450 585281 589152 591327 595785 603236 603891 605334 614262 622199 623892 625736 631908 640083 648924 651489 661286 667757 668380 670717 676887 677881 686073 687639 690851 692419 703538 707557 710396 718788 720740 722277 723892 731356 742214 752569 766096 766129 768581 775758 775855 806378 809502 810466 827420 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебут толпой частное"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс группов секс любительск"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.