Query Metrics
7
Database Queries
7
Different statements
158.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.22 ms (80.93%) |
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 95742 96048 307940 383635 391523 396307 400662 401629 402715 405182 409929 410791 411561 413711 414055 414381 415785 416382 417726 420191 420461 422098 422143 422373 422413 425902 426336 426383 426598 428481 429151 430490 432662 433106 434277 435916 435965 436093 441195 443113 443364 444736 444803 445679 447277 447361 447750 448371 448806 449048 449856 451755 452057 453383 454522 454696 456541 461784 463223 466572 466850 470131 472510 476956 478281 483180 486863 487577 488156 488809 490720 490831 491177 492232 493356 495421 496810 503428 504684 504829 506335 508533 509330 510522 514218 516391 516473 517559 519180 519547 520627 520961 521499 522028 523307 523741 523913 525601 526917 527666 528208 540696 542102 543841 559445 560469 560597 562333 562904 564593 566759 573885 574723 575808 581531 587931 590406 591935 599056 613924 ] |
||||||||||||||||||||||||||||||
|
19.50 ms (12.30%) |
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 516391 492232 581531 405182 445679 454522 483180 508533 516473 522028 420461 428481 391523 411561 466850 573885 587931 599056 426383 432662 493356 528208 488156 560469 559445 591935 434277 613924 425902 415785 490831 542102 429151 426336 413711 506335 417726 470131 590406 476956 444803 472510 410791 449856 422373 478281 95742 540696 307940 562333 523307 463223 491177 447277 456541 422413 461784 448371 488809 490720 525601 96048 400662 443113 444736 426598 409929 422143 454696 503428 564593 448806 402715 416382 420191 449048 452057 401629 436093 447361 447750 509330 495421 517559 519547 504829 519180 510522 414055 443364 433106 422098 487577 520961 523913 435965 575808 560597 523741 562904 574723 566759 435916 451755 396307 521499 496810 527666 543841 504684 430490 414381 453383 486863 466572 526917 514218 520627 383635 441195 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.71%) |
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 95742 96048 307940 383635 391523 396307 400662 401629 402715 405182 409929 410791 411561 413711 414055 414381 415785 416382 417726 420191 420461 422098 422143 422373 422413 425902 426336 426383 426598 428481 429151 430490 432662 433106 434277 435916 435965 436093 441195 443113 443364 444736 444803 445679 447277 447361 447750 448371 448806 449048 449856 451755 452057 453383 454522 454696 456541 461784 463223 466572 466850 470131 472510 476956 478281 483180 486863 487577 488156 488809 490720 490831 491177 492232 493356 495421 496810 503428 504684 504829 506335 508533 509330 510522 514218 516391 516473 517559 519180 519547 520627 520961 521499 522028 523307 523741 523913 525601 526917 527666 528208 540696 542102 543841 559445 560469 560597 562333 562904 564593 566759 573885 574723 575808 581531 587931 590406 591935 599056 613924 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.55%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большой член в глотку…"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большой большие член в глотк"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.