Query Metrics
7
Database Queries
7
Different statements
214.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.22 ms (86.86%) |
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 8295 34645 80536 102043 185038 185332 185401 204992 350700 357845 382957 383486 383592 383697 385389 386263 386518 387182 388001 390050 390215 390804 390832 395920 397290 398918 406191 406404 406438 408043 408172 409291 411012 411555 413104 416177 419794 421235 436628 450656 451116 452212 453555 456792 459231 459760 469825 469828 472212 474823 476366 476812 477168 481284 489225 498869 540958 545472 545774 551319 551397 551432 552232 560108 604116 621538 623570 623955 624709 634755 643423 643879 644225 653260 661881 663375 666321 672485 672564 676130 676499 676576 679706 682268 689743 699505 701469 706668 709408 709769 712166 721225 722820 725375 730686 737921 749522 749623 756363 759547 764158 767748 770096 770438 771584 775621 779965 782003 788822 789660 797688 800005 802367 811236 812078 813949 815428 815751 816818 823530 ] |
||||||||||||||||||||||||||||||
|
18.90 ms (8.82%) |
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 815428 823530 469828 545472 540958 552232 653260 666321 679706 699505 676130 709408 712166 661881 676499 706668 709769 721225 623570 644225 623955 621538 643423 811236 725375 788822 797688 802367 812078 767748 764158 730686 759547 771584 770438 604116 624709 643879 775621 789660 416177 8295 545774 385389 80536 383592 185332 34645 390215 421235 411012 413104 419794 436628 815751 453555 474823 459760 476812 477168 450656 459231 469825 498869 472212 676576 689743 663375 672485 672564 701469 682268 551319 749623 756363 770096 800005 749522 737921 634755 722820 779965 782003 350700 382957 388001 409291 456792 481284 102043 386518 390832 397290 398918 386263 476366 411555 383486 383697 204992 185038 185401 395920 357845 387182 390804 390050 406191 406438 406404 408043 408172 813949 816818 452212 489225 451116 551397 551432 560108 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.41%) |
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 8295 34645 80536 102043 185038 185332 185401 204992 350700 357845 382957 383486 383592 383697 385389 386263 386518 387182 388001 390050 390215 390804 390832 395920 397290 398918 406191 406404 406438 408043 408172 409291 411012 411555 413104 416177 419794 421235 436628 450656 451116 452212 453555 456792 459231 459760 469825 469828 472212 474823 476366 476812 477168 481284 489225 498869 540958 545472 545774 551319 551397 551432 552232 560108 604116 621538 623570 623955 624709 634755 643423 643879 644225 653260 661881 663375 666321 672485 672564 676130 676499 676576 679706 682268 689743 699505 701469 706668 709408 709769 712166 721225 722820 725375 730686 737921 749522 749623 756363 759547 764158 767748 770096 770438 771584 775621 779965 782003 788822 789660 797688 800005 802367 811236 812078 813949 815428 815751 816818 823530 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage in massage"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж массаж"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.