Query Metrics
7
Database Queries
7
Different statements
153.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.60 ms (84.26%) |
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 187567 385228 386686 395651 395751 396456 396806 400150 400986 401142 401306 404318 404552 410267 410936 411958 415200 421562 425714 428703 444727 445903 452296 452828 456929 459324 461723 462470 463298 472223 473182 478459 482080 482174 484483 486130 491849 491857 494695 496073 504479 509600 512973 515090 518470 520736 522861 523985 525046 527607 529198 529855 530494 531090 534028 539210 540175 550609 550629 565249 565255 568579 571214 574897 581096 581700 594209 595853 597072 597227 597940 598042 598057 598723 603077 604968 623963 624829 626735 628090 628388 628409 628419 628424 631980 648583 649190 663321 668524 675537 680154 680260 684949 685686 695898 696212 702164 702927 703897 720056 720462 721400 727753 744601 758196 776488 788958 800517 804995 806324 807968 815778 816503 821068 821503 821829 822295 823173 826182 827328 ] |
||||||||||||||||||||||||||||||
|
14.92 ms (9.70%) |
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 685686 680260 597940 623963 804995 807968 727753 744601 758196 776488 187567 400986 459324 386686 396806 452296 550629 550609 568579 675537 482174 581096 461723 410267 530494 531090 565249 574897 565255 680154 702164 648583 702927 598723 595853 597227 598057 628090 628388 628409 603077 806324 518470 395751 445903 462470 452828 478459 529855 539210 525046 534028 529198 696212 720056 598042 628424 628419 415200 410936 421562 463298 482080 428703 404318 473182 486130 520736 484483 494695 512973 523985 385228 395651 396456 400150 401142 401306 404552 411958 425714 444727 821503 823173 815778 822295 826182 827328 816503 821068 821829 456929 522861 509600 540175 496073 504479 515090 527607 472223 491849 491857 663321 721400 649190 668524 684949 695898 703897 720462 571214 581700 604968 631980 597072 624829 626735 594209 788958 800517 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (2.03%) |
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 187567 385228 386686 395651 395751 396456 396806 400150 400986 401142 401306 404318 404552 410267 410936 411958 415200 421562 425714 428703 444727 445903 452296 452828 456929 459324 461723 462470 463298 472223 473182 478459 482080 482174 484483 486130 491849 491857 494695 496073 504479 509600 512973 515090 518470 520736 522861 523985 525046 527607 529198 529855 530494 531090 534028 539210 540175 550609 550629 565249 565255 568579 571214 574897 581096 581700 594209 595853 597072 597227 597940 598042 598057 598723 603077 604968 623963 624829 626735 628090 628388 628409 628419 628424 631980 648583 649190 663321 668524 675537 680154 680260 684949 685686 695898 696212 702164 702927 703897 720056 720462 721400 727753 744601 758196 776488 788958 800517 804995 806324 807968 815778 816503 821068 821503 821829 822295 823173 826182 827328 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen old big"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen old большие"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen old большие"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.87%) |
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.