Query Metrics
7
Database Queries
7
Different statements
168.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.15 ms (85.73%) |
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 108555 238715 301402 382104 385687 387477 394509 395940 421108 421673 422732 438588 442255 444321 455430 468912 470670 477621 486454 486816 486892 501433 501505 504034 507086 513483 520930 528507 528674 530684 531902 536012 536031 538329 551651 557251 570847 570875 573997 585498 585520 587541 587831 588344 588367 591213 594899 600331 600757 600783 600846 600853 617044 624899 627212 627738 635903 636252 637869 643220 689840 689860 689877 689898 692434 700842 700898 701890 702067 708494 709976 710074 710489 711617 715071 716204 718407 718851 723952 724157 725464 725502 727475 730979 735828 735901 736051 737333 739250 744093 750107 752951 755134 758310 759037 760083 760633 760692 760860 762261 766152 767639 768206 769253 770236 778716 785666 786433 787276 787745 794109 794855 795711 796752 799925 803536 811021 811584 813573 ] |
||||||||||||||||||||||||||||||
|
12.83 ms (7.63%) |
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 718407 702067 600853 627738 588367 600846 624899 709976 710489 718851 238715 301402 486816 689877 715071 587541 799925 750107 786433 787745 794855 735828 752951 760878 727475 736051 766152 744093 442255 382104 536031 470670 570847 689898 692434 689840 585498 587831 600783 778716 759037 760633 724157 769253 725464 737333 739250 760692 636252 813573 501505 486892 536012 504034 573997 708494 710074 711617 600757 635903 637869 617044 643220 588344 600331 627212 387477 795711 811021 811584 395940 394509 486454 385687 108555 557251 570875 551651 585520 794109 796752 723952 725502 758310 785666 787276 730979 760083 762261 770236 735901 755134 760860 767639 768206 803536 421108 422732 444321 438588 468912 520930 591213 594899 421673 455430 501433 507086 513483 528507 528674 477621 538329 531902 530684 689860 700898 701890 716204 700842 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (2.37%) |
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 108555 238715 301402 382104 385687 387477 394509 395940 421108 421673 422732 438588 442255 444321 455430 468912 470670 477621 486454 486816 486892 501433 501505 504034 507086 513483 520930 528507 528674 530684 531902 536012 536031 538329 551651 557251 570847 570875 573997 585498 585520 587541 587831 588344 588367 591213 594899 600331 600757 600783 600846 600853 617044 624899 627212 627738 635903 636252 637869 643220 689840 689860 689877 689898 692434 700842 700898 701890 702067 708494 709976 710074 710489 711617 715071 716204 718407 718851 723952 724157 725464 725502 727475 730979 735828 735901 736051 737333 739250 744093 750107 752951 755134 758310 759037 760083 760633 760692 760860 762261 766152 767639 768206 769253 770236 778716 785666 786433 787276 787745 794109 794855 795711 796752 799925 803536 811021 811584 813573 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur office"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск секретарш"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.93%) |
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.