Query Metrics
7
Database Queries
7
Different statements
154.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.61 ms (82.15%) |
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 383248 411515 411868 418865 423804 427388 433558 453301 454288 455125 455958 457179 458488 460559 463104 465563 468832 470804 479354 480667 482340 483286 483435 496422 497025 505502 513552 517371 518424 518816 520940 523157 526446 541130 542071 542628 552719 555095 556199 557433 560523 560961 562732 564843 565657 566651 569401 571072 579454 579873 581246 583328 585225 585326 586220 586245 586248 586266 586274 586294 586327 587014 589617 589664 589811 591724 595601 599360 603882 604343 613606 613630 615936 617363 618752 623328 623488 625175 625578 625863 629446 630445 630955 635007 638894 643929 644192 661896 661931 669213 670246 671650 689172 691414 692127 697416 698082 715972 718556 721280 721867 721935 722341 724292 730947 736736 740157 752790 755627 756270 757724 758114 758232 761699 779913 782232 788377 795226 804894 825949 ] |
||||||||||||||||||||||||||||||
|
17.31 ms (11.23%) |
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 618752 721280 433558 505502 518816 453301 455958 758232 411868 427388 455125 497025 383248 454288 457179 566651 542628 569401 579454 589664 757724 755627 613606 480667 418865 465563 470804 483286 483435 460559 468832 520940 523157 526446 496422 517371 560523 669213 715972 586274 643929 782232 623488 463104 479354 482340 513552 518424 825949 542071 565657 581246 583328 557433 562732 571072 541130 552719 555095 556199 564843 670246 691414 698082 721935 661896 689172 692127 718556 722341 661931 671650 697416 721867 560961 579873 586220 586245 586294 589811 595601 604343 615936 617363 625863 629446 586266 589617 599360 630445 644192 585225 585326 586248 586327 587014 591724 623328 625175 635007 613630 625578 638894 779913 804894 788377 795226 756270 736736 724292 740157 752790 730947 758114 761699 603882 630955 458488 411515 423804 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.95%) |
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 383248 411515 411868 418865 423804 427388 433558 453301 454288 455125 455958 457179 458488 460559 463104 465563 468832 470804 479354 480667 482340 483286 483435 496422 497025 505502 513552 517371 518424 518816 520940 523157 526446 541130 542071 542628 552719 555095 556199 557433 560523 560961 562732 564843 565657 566651 569401 571072 579454 579873 581246 583328 585225 585326 586220 586245 586248 586266 586274 586294 586327 587014 589617 589664 589811 591724 595601 599360 603882 604343 613606 613630 615936 617363 618752 623328 623488 625175 625578 625863 629446 630445 630955 635007 638894 643929 644192 661896 661931 669213 670246 671650 689172 691414 692127 697416 698082 715972 718556 721280 721867 721935 722341 724292 730947 736736 740157 752790 755627 756270 757724 758114 758232 761699 779913 782232 788377 795226 804894 825949 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big neighbor"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие neighbor"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие neighbor"
]
|
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.