Query Metrics
7
Database Queries
7
Different statements
301.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
275.05 ms (91.13%) |
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 118086 385021 385225 386522 397251 401003 408911 414132 414601 420254 423953 428171 428220 428255 441057 441063 441093 441111 441207 441269 441925 442978 443309 446492 447100 449075 454926 456050 457698 458086 459659 464042 476728 477532 479530 481441 487970 489946 491583 493735 494495 495067 500724 509063 511255 512922 514946 517634 517717 519722 521835 522705 528346 529331 530956 531561 533557 533724 535277 535308 535458 536421 536440 537264 537452 539559 541540 541797 544200 551892 552131 552603 554862 555282 557268 558098 560939 565909 566914 567947 568770 569072 569247 571126 571846 574089 575665 575928 579471 581050 582088 584402 590271 592009 592245 594300 594775 596350 601367 604322 604815 606651 609244 613494 618844 619108 631145 634602 636428 636592 636956 642700 650726 671205 676642 680440 686576 688980 689415 727560 ] |
||||||||||||||||||||||||||||||
|
15.11 ms (5.01%) |
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 491583 454926 464042 539559 560939 575665 680440 606651 594300 613494 541540 642700 441093 441111 443309 441057 428220 428255 441063 688980 446492 458086 493735 456050 487970 476728 489946 500724 494495 536440 537264 537452 495067 519722 514946 522705 528346 530956 533724 535458 536421 552131 567947 581050 544200 555282 558098 569247 551892 568770 689415 650726 671205 676642 592245 596350 636956 601367 604322 619108 631145 727560 397251 449075 441207 447100 428171 441925 459659 512922 521835 386522 408911 442978 457698 531561 535277 541797 594775 618844 479530 401003 385225 420254 414601 509063 441269 414132 477532 511255 517717 535308 517634 529331 481441 571846 575928 582088 552603 565909 571126 574089 579471 584402 686576 557268 569072 636592 590271 604815 636428 609244 592009 634602 118086 423953 385021 533557 566914 554862 ] |
||||||||||||||||||||||||||||||
|
4.91 ms (1.63%) |
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 118086 385021 385225 386522 397251 401003 408911 414132 414601 420254 423953 428171 428220 428255 441057 441063 441093 441111 441207 441269 441925 442978 443309 446492 447100 449075 454926 456050 457698 458086 459659 464042 476728 477532 479530 481441 487970 489946 491583 493735 494495 495067 500724 509063 511255 512922 514946 517634 517717 519722 521835 522705 528346 529331 530956 531561 533557 533724 535277 535308 535458 536421 536440 537264 537452 539559 541540 541797 544200 551892 552131 552603 554862 555282 557268 558098 560939 565909 566914 567947 568770 569072 569247 571126 571846 574089 575665 575928 579471 581050 582088 584402 590271 592009 592245 594300 594775 596350 601367 604322 604815 606651 609244 613494 618844 619108 631145 634602 636428 636592 636956 642700 650726 671205 676642 680440 686576 688980 689415 727560 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в жопу рукой"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал рук"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.52%) |
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.