Query Metrics
7
Database Queries
7
Different statements
178.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.48 ms (85.46%) |
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 336938 395684 401470 416676 421077 421152 421162 422646 423633 426281 426390 428028 429553 432843 439662 441500 443524 445289 445323 447521 447722 447898 449666 451261 451327 451788 452382 452456 456813 459805 464159 468396 468684 469200 474688 479926 481807 487418 491606 491610 492029 492528 493391 495792 500207 504733 508224 511895 512514 513412 514721 515339 519299 519872 522300 522681 524876 528123 528519 530700 532876 538703 539278 544150 544846 558720 559567 560608 560867 563548 568123 570906 575710 577386 578501 578527 578596 583377 583686 588146 592652 596488 598638 600010 604109 614696 618861 620163 627635 630806 633454 636540 639301 643404 656126 669302 696426 700631 710080 714463 720878 728324 729344 732070 750152 769400 771829 771918 786463 788196 793431 796143 800533 801953 806078 806903 809440 809782 814861 817142 ] |
||||||||||||||||||||||||||||||
|
15.77 ms (8.84%) |
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 578501 588146 592652 600010 401470 451327 421152 447521 479926 524876 504733 528519 336938 451788 495792 528123 487418 560867 570906 560608 568123 614696 627635 806078 771918 441500 481807 558720 426390 817142 508224 491610 696426 656126 710080 714463 720878 596488 604109 643404 620163 639301 796143 800533 809782 801953 806903 729344 732070 771829 636540 700631 421077 492029 522300 423633 578527 439662 445323 513412 429553 421162 500207 519872 515339 532876 577386 395684 456813 468684 416676 428028 464159 514721 519299 544150 443524 449666 452456 447898 530700 539278 575710 578596 583686 563548 618861 786463 469200 492528 511895 522681 559567 432843 512514 491606 426281 422646 445289 814861 538703 544846 583377 669302 598638 630806 633454 788196 793431 728324 750152 769400 809440 468396 452382 474688 447722 451261 493391 459805 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.62%) |
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 336938 395684 401470 416676 421077 421152 421162 422646 423633 426281 426390 428028 429553 432843 439662 441500 443524 445289 445323 447521 447722 447898 449666 451261 451327 451788 452382 452456 456813 459805 464159 468396 468684 469200 474688 479926 481807 487418 491606 491610 492029 492528 493391 495792 500207 504733 508224 511895 512514 513412 514721 515339 519299 519872 522300 522681 524876 528123 528519 530700 532876 538703 539278 544150 544846 558720 559567 560608 560867 563548 568123 570906 575710 577386 578501 578527 578596 583377 583686 588146 592652 596488 598638 600010 604109 614696 618861 620163 627635 630806 633454 636540 639301 643404 656126 669302 696426 700631 710080 714463 720878 728324 729344 732070 750152 769400 771829 771918 786463 788196 793431 796143 800533 801953 806078 806903 809440 809782 814861 817142 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best анал"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best of anal"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best анал"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.