Query Metrics
7
Database Queries
7
Different statements
168.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.54 ms (84.12%) |
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 96269 387550 390024 390994 391275 395702 401127 403348 404952 410093 410937 410941 413376 413398 414259 419064 424791 426032 429763 430261 431805 436718 447144 448552 451565 452843 459383 459395 473782 474977 478548 482194 483691 484791 486515 494151 497590 497805 503673 509875 510160 522310 523312 525020 530054 530623 530798 531227 531239 532669 532981 535582 536292 536546 537201 537909 537931 537933 537986 545407 545416 550198 550669 558124 575140 597254 605851 613516 632658 633807 634154 636991 637432 640777 641070 645327 647928 647937 648836 648845 648862 649192 650794 651144 651620 671761 672711 673570 677671 679025 679721 679770 679775 679821 680156 687262 691409 696949 704226 707889 715670 719001 720684 720837 720871 721298 722776 722821 740251 742449 748950 751435 760957 761231 770396 770405 790366 800331 805023 806423 ] |
||||||||||||||||||||||||||||||
|
16.48 ms (9.79%) |
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 719001 650794 671761 679025 679770 696949 722776 648862 651620 679775 704226 707889 720684 720837 720871 558124 597254 613516 634154 637432 632658 636991 605851 640777 790366 805023 806423 742449 800331 740251 770405 760957 748950 761231 770396 751435 633807 641070 721298 413398 414259 431805 96269 403348 410093 474977 424791 430261 459383 482194 395702 410937 413376 451565 478548 483691 497590 522310 525020 503673 387550 390024 390994 391275 401127 404952 426032 436718 429763 410941 419064 447144 452843 473782 484791 448552 459395 486515 497805 510160 531239 535582 536546 537931 494151 523312 531227 532669 537201 537909 537986 530054 530798 509875 530623 532981 536292 537933 550669 545407 545416 550198 575140 648845 649192 651144 679721 647937 648836 672711 673570 677671 679821 715670 722821 645327 647928 680156 687262 691409 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (1.87%) |
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 96269 387550 390024 390994 391275 395702 401127 403348 404952 410093 410937 410941 413376 413398 414259 419064 424791 426032 429763 430261 431805 436718 447144 448552 451565 452843 459383 459395 473782 474977 478548 482194 483691 484791 486515 494151 497590 497805 503673 509875 510160 522310 523312 525020 530054 530623 530798 531227 531239 532669 532981 535582 536292 536546 537201 537909 537931 537933 537986 545407 545416 550198 550669 558124 575140 597254 605851 613516 632658 633807 634154 636991 637432 640777 641070 645327 647928 647937 648836 648845 648862 649192 650794 651144 651620 671761 672711 673570 677671 679025 679721 679770 679775 679821 680156 687262 691409 696949 704226 707889 715670 719001 720684 720837 720871 721298 722776 722821 740251 742449 748950 751435 760957 761231 770396 770405 790366 800331 805023 806423 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens double"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens double"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens double"
]
|
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.