Query Metrics
7
Database Queries
7
Different statements
378.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
230.06 ms (60.77%) |
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 617369 626580 631483 635123 635602 591931 595355 599151 602626 602635 610257 614923 621060 622028 622858 625949 588772 591158 589281 603112 622871 605005 630080 30533 395624 396052 432387 455071 465896 28242 250457 391557 435282 459731 475775 34812 381747 401498 403827 431839 473847 365954 400495 448080 453479 463010 512852 503417 503551 527579 514438 519369 395809 31604 389715 387525 400290 400363 398632 406847 444376 411535 671131 447847 453947 461091 468803 471335 479674 453778 454833 455477 477569 487607 487790 490781 491313 454493 455790 458587 459629 460401 490628 495855 505144 512962 520999 525495 525505 527406 530032 535626 535949 538483 539493 540393 498890 507586 508660 508845 509114 511258 513378 522173 522751 525151 529539 540311 499874 505633 512956 514454 516348 518154 518944 521374 523889 524869 525370 536270 ] |
||||||||||||||||||||||||||||||
|
137.90 ms (36.43%) |
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 28242 30533 31604 34812 250457 365954 381747 387525 389715 391557 395624 395809 396052 398632 400290 400363 400495 401498 403827 406847 411535 431839 432387 435282 444376 447847 448080 453479 453778 453947 454493 454833 455071 455477 455790 458587 459629 459731 460401 461091 463010 465896 468803 471335 473847 475775 477569 479674 487607 487790 490628 490781 491313 495855 498890 499874 503417 503551 505144 505633 507586 508660 508845 509114 511258 512852 512956 512962 513378 514438 514454 516348 518154 518944 519369 520999 521374 522173 522751 523889 524869 525151 525370 525495 525505 527406 527579 529539 530032 535626 535949 536270 538483 539493 540311 540393 588772 589281 591158 591931 595355 599151 602626 602635 603112 605005 610257 614923 617369 621060 622028 622858 622871 625949 626580 630080 631483 635123 635602 671131 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (0.83%) |
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 28242 30533 31604 34812 250457 365954 381747 387525 389715 391557 395624 395809 396052 398632 400290 400363 400495 401498 403827 406847 411535 431839 432387 435282 444376 447847 448080 453479 453778 453947 454493 454833 455071 455477 455790 458587 459629 459731 460401 461091 463010 465896 468803 471335 473847 475775 477569 479674 487607 487790 490628 490781 491313 495855 498890 499874 503417 503551 505144 505633 507586 508660 508845 509114 511258 512852 512956 512962 513378 514438 514454 516348 518154 518944 519369 520999 521374 522173 522751 523889 524869 525151 525370 525495 525505 527406 527579 529539 530032 535626 535949 536270 538483 539493 540311 540393 588772 589281 591158 591931 595355 599151 602626 602635 603112 605005 610257 614923 617369 621060 622028 622858 622871 625949 626580 630080 631483 635123 635602 671131 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"боку"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"бок"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.46%) |
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.