Query Metrics
7
Database Queries
7
Different statements
174.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.32 ms (83.80%) |
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 31432 383748 400719 400912 417198 428703 428891 436030 436037 436042 437817 443387 447031 447314 451552 453068 453070 453073 453089 453183 455016 456660 457776 457791 459158 464301 470273 470291 471170 472358 475971 476230 482782 483756 484165 484848 486390 486434 487120 487138 488730 489990 489998 490024 490843 490868 491633 495275 495866 497550 497553 497572 497581 500901 504098 505642 510617 511259 511780 512823 514704 515167 515179 518468 519385 522380 522696 525138 525628 526277 527074 527605 527647 527648 529114 541661 543599 543605 543615 544299 546083 548226 551032 551223 551235 552617 554751 558425 558614 559133 562359 563388 565362 566694 566695 566696 567467 568446 570719 577376 598648 599999 617132 619830 633312 644275 644296 645706 661281 668380 690787 706945 706949 719055 760928 793341 809902 821232 821609 822219 ] |
||||||||||||||||||||||||||||||
|
18.23 ms (10.44%) |
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 437817 471170 527648 495275 661281 821609 443387 497581 428891 436037 447314 526277 476230 457791 505642 487120 566696 619830 529114 551235 563388 487138 500901 484848 453089 519385 497553 633312 525138 558425 475971 527074 495866 483756 525628 543605 486434 453068 484165 543615 822219 543599 400719 510617 644275 383748 515179 598648 552617 447031 464301 558614 428703 470291 482782 544299 562359 760928 554751 489990 504098 527647 459158 551223 457776 706949 793341 470273 488730 511780 453183 548226 567467 821232 599999 644296 436030 453073 541661 645706 472358 490843 617132 518468 668380 566695 809902 551032 577376 490868 486390 512823 527605 417198 31432 455016 497572 511259 491633 400912 456660 497550 489998 453070 690787 719055 566694 568446 514704 490024 522696 522380 559133 570719 706945 546083 451552 515167 565362 436042 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.71%) |
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 31432 383748 400719 400912 417198 428703 428891 436030 436037 436042 437817 443387 447031 447314 451552 453068 453070 453073 453089 453183 455016 456660 457776 457791 459158 464301 470273 470291 471170 472358 475971 476230 482782 483756 484165 484848 486390 486434 487120 487138 488730 489990 489998 490024 490843 490868 491633 495275 495866 497550 497553 497572 497581 500901 504098 505642 510617 511259 511780 512823 514704 515167 515179 518468 519385 522380 522696 525138 525628 526277 527074 527605 527647 527648 529114 541661 543599 543605 543615 544299 546083 548226 551032 551223 551235 552617 554751 558425 558614 559133 562359 563388 565362 566694 566695 566696 567467 568446 570719 577376 598648 599999 617132 619830 633312 644275 644296 645706 661281 668380 690787 706945 706949 719055 760928 793341 809902 821232 821609 822219 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"групповую на природе"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"группов на природ"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.81%) |
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.