Query Metrics
7
Database Queries
7
Different statements
149.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.88 ms (82.01%) |
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 410255 412097 415831 417021 418627 419185 419950 423670 424299 425544 434459 435500 437619 443978 445324 446580 447947 450135 450165 452463 452588 453350 453502 455153 455354 456065 456936 457048 457081 459002 459364 459865 460294 460583 461688 463661 465235 466489 467684 469751 472680 473758 474309 475442 480125 481159 486223 486859 486872 490440 491629 492126 493875 494814 495253 495613 495965 498435 500016 500871 506232 506441 510838 510869 511452 512581 517646 518334 518821 519207 519670 519867 521492 521647 522653 523589 523878 525200 525360 526368 538478 539662 542127 544042 544104 546116 547819 556116 557810 564172 565695 567074 569541 573313 573736 575675 580142 581199 581959 584382 584635 592921 600851 602463 616566 619090 636490 648740 652010 655462 680746 717274 719808 726306 750171 769425 789490 790736 791505 796072 ] |
||||||||||||||||||||||||||||||
|
15.99 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 573313 547819 415831 450135 466489 523589 472680 546116 717274 652010 790736 726306 750171 455354 424299 453502 435500 495965 419185 418627 465235 510838 544042 544104 556116 575675 636490 796072 616566 443978 456065 434459 500871 518821 494814 680746 655462 567074 592921 600851 473758 461688 491629 519867 791505 410255 506441 539662 518334 486859 425544 445324 452588 459364 486872 519207 525200 493875 569541 719808 557810 564172 789490 474309 519670 492126 459002 459865 495253 522653 542127 581959 565695 602463 769425 423670 460583 456936 467684 475442 437619 460294 490440 486223 523878 498435 512581 525360 457081 506232 457048 510869 446580 619090 447947 453350 521492 526368 584635 573736 581199 584382 580142 452463 521647 500016 495613 419950 450165 517646 538478 481159 648740 417021 463661 480125 455153 412097 469751 511452 ] |
||||||||||||||||||||||||||||||
|
3.68 ms (2.46%) |
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 410255 412097 415831 417021 418627 419185 419950 423670 424299 425544 434459 435500 437619 443978 445324 446580 447947 450135 450165 452463 452588 453350 453502 455153 455354 456065 456936 457048 457081 459002 459364 459865 460294 460583 461688 463661 465235 466489 467684 469751 472680 473758 474309 475442 480125 481159 486223 486859 486872 490440 491629 492126 493875 494814 495253 495613 495965 498435 500016 500871 506232 506441 510838 510869 511452 512581 517646 518334 518821 519207 519670 519867 521492 521647 522653 523589 523878 525200 525360 526368 538478 539662 542127 544042 544104 546116 547819 556116 557810 564172 565695 567074 569541 573313 573736 575675 580142 581199 581959 584382 584635 592921 600851 602463 616566 619090 636490 648740 652010 655462 680746 717274 719808 726306 750171 769425 789490 790736 791505 796072 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur swallows"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск swallows"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск swallows"
]
|
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.