Query Metrics
7
Database Queries
7
Different statements
160.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.95 ms (84.35%) |
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 387155 396524 399959 403054 416066 416151 416244 417773 428750 428753 429910 435406 435973 437476 444213 445109 446150 446328 449531 453802 455390 457186 457869 462089 462865 464874 465873 468025 468119 468274 470317 472122 475076 477776 479943 480523 482937 484009 485031 485414 487172 487654 488361 489035 490758 491170 496376 496454 497430 499164 499302 502292 508534 509180 513051 515199 521650 523157 524598 526126 527203 527914 529492 533566 534077 535699 536089 536914 539293 542113 554245 555810 571218 571474 574240 577896 585437 588258 592364 595611 597258 597260 597264 600667 601425 602504 615281 617865 618544 619389 619612 619994 624184 630576 639108 649730 650740 652513 655188 655275 663207 684701 685889 698301 717906 723933 735593 735704 739517 745345 747451 751512 755406 760468 765891 775015 777306 778671 789566 794906 ] |
||||||||||||||||||||||||||||||
|
14.81 ms (9.25%) |
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 457186 446328 457869 464874 482937 485031 487172 508534 515199 523157 536914 496454 533566 535699 524598 536089 539293 527203 529492 477776 485414 571474 542113 571218 577896 649730 655188 655275 663207 684701 685889 650740 652513 698301 554245 555810 574240 595611 597260 601425 624184 639108 585437 597258 597264 600667 619389 619612 588258 592364 602504 619994 618544 630576 777306 723933 735593 735704 739517 760468 747451 755406 745345 765891 751512 615281 617865 717906 775015 778671 789566 794906 387155 435973 446150 475076 480523 399959 429910 453802 465873 468119 468274 470317 428750 444213 462865 479943 396524 403054 416244 417773 428753 449531 462089 416066 416151 435406 437476 445109 455390 468025 472122 521650 489035 491170 499302 513051 526126 527914 484009 487654 488361 496376 497430 499164 502292 509180 534077 490758 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.04%) |
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 387155 396524 399959 403054 416066 416151 416244 417773 428750 428753 429910 435406 435973 437476 444213 445109 446150 446328 449531 453802 455390 457186 457869 462089 462865 464874 465873 468025 468119 468274 470317 472122 475076 477776 479943 480523 482937 484009 485031 485414 487172 487654 488361 489035 490758 491170 496376 496454 497430 499164 499302 502292 508534 509180 513051 515199 521650 523157 524598 526126 527203 527914 529492 533566 534077 535699 536089 536914 539293 542113 554245 555810 571218 571474 574240 577896 585437 588258 592364 595611 597258 597260 597264 600667 601425 602504 615281 617865 618544 619389 619612 619994 624184 630576 639108 649730 650740 652513 655188 655275 663207 684701 685889 698301 717906 723933 735593 735704 739517 745345 747451 751512 755406 760468 765891 775015 777306 778671 789566 794906 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"little teens"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"little teens"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"little teens"
]
|
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.