Query Metrics
7
Database Queries
7
Different statements
433.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.99 ms (48.24%) |
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 79574 115020 384574 387664 390492 393049 397214 398368 402719 405897 413101 417799 422305 423462 425504 426455 426689 429300 430796 432945 434569 434817 436058 436089 437790 439055 441972 444326 444697 444803 447232 447261 451466 452336 456017 456117 459363 460230 460324 463067 468668 470347 475167 475934 480438 484747 489260 490706 493264 494671 495927 497962 500390 502508 504985 510696 517802 518972 519685 525123 531360 540739 544104 546259 546806 548017 553284 553665 559373 564485 567587 569788 573750 573927 578584 580401 586102 588555 589034 590355 590754 591925 591935 592730 599542 600767 602973 606101 607772 623388 626352 635144 642559 652121 659022 660754 661462 661976 665916 669399 700179 707480 709286 712540 716607 716660 719765 721557 774805 775184 775892 786265 786654 787802 788895 791106 793593 793629 796581 800354 ] |
||||||||||||||||||||||||||||||
|
200.66 ms (46.31%) |
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 79574 115020 384574 387664 390492 393049 397214 398368 402719 405897 413101 417799 422305 423462 425504 426455 426689 429300 430796 432945 434569 434817 436058 436089 437790 439055 441972 444326 444697 444803 447232 447261 451466 452336 456017 456117 459363 460230 460324 463067 468668 470347 475167 475934 480438 484747 489260 490706 493264 494671 495927 497962 500390 502508 504985 510696 517802 518972 519685 525123 531360 540739 544104 546259 546806 548017 553284 553665 559373 564485 567587 569788 573750 573927 578584 580401 586102 588555 589034 590355 590754 591925 591935 592730 599542 600767 602973 606101 607772 623388 626352 635144 642559 652121 659022 660754 661462 661976 665916 669399 700179 707480 709286 712540 716607 716660 719765 721557 774805 775184 775892 786265 786654 787802 788895 791106 793593 793629 796581 800354 ] |
||||||||||||||||||||||||||||||
|
16.50 ms (3.81%) |
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 635144 700179 709286 716607 774805 775184 775892 786265 786654 787802 788895 791106 793593 793629 796581 800354 436058 451466 452336 460230 402719 417799 426689 434569 456117 480438 398368 439055 470347 475167 397214 413101 429300 444803 475934 510696 484747 540739 500390 79574 384574 115020 393049 390492 387664 405897 425504 430796 441972 423462 426455 434817 436089 444326 422305 432945 437790 444697 447232 463067 447261 456017 459363 460324 493264 497962 504985 518972 502508 519685 494671 517802 531360 495927 525123 468668 489260 490706 546259 553284 553665 573750 564485 569788 578584 544104 546806 559373 573927 580401 659022 661462 661976 669399 716660 719765 721557 652121 660754 665916 707480 712540 548017 567587 588555 600767 590355 591925 591935 607772 626352 642559 586102 589034 590754 592730 599542 602973 606101 623388 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"throat throat"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"throat throat"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"throat throat"
]
|
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.