Query Metrics
7
Database Queries
7
Different statements
161.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.67 ms (81.58%) |
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 236863 383326 391541 394764 395606 401321 411319 417978 418419 421071 422351 423301 425799 427113 429571 431546 432426 432448 432472 432476 432477 432507 432569 433571 433584 434077 434783 436074 437914 439518 441572 443372 446369 451089 455798 457059 465182 465905 469233 469698 469921 475134 475658 475847 477675 481459 483159 483652 484958 485701 490606 491174 491516 492063 492272 494805 494814 496174 496669 497193 498905 500146 500157 500186 500386 500429 505077 509669 511312 514808 515167 515565 518602 520703 521715 523150 524226 524522 526139 526345 526799 528035 528190 535063 547880 549622 549638 550409 552278 563155 564383 565181 567703 568072 568604 569622 569788 572631 574493 575123 581710 586563 594644 595252 596809 598233 600222 600898 601529 601616 602705 603829 609205 609731 610255 611500 617134 627383 653537 662567 ] |
||||||||||||||||||||||||||||||
|
19.76 ms (12.24%) |
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 443372 423301 594644 469921 581710 586563 422351 418419 492063 500429 549622 602705 431546 465182 391541 496669 526139 497193 520703 383326 411319 475847 483159 465905 455798 483652 494805 491516 547880 569622 569788 662567 432476 432507 432569 432426 432448 432472 469233 433571 451089 434783 500146 500157 518602 500186 511312 498905 528190 494814 236863 394764 563155 524522 485701 572631 596809 515167 395606 475658 603829 475134 469698 500386 535063 432477 441572 433584 434077 457059 437914 427113 491174 526799 528035 505077 429571 575123 401321 492272 526345 425799 567703 515565 417978 552278 600898 595252 523150 509669 524226 521715 568604 598233 421071 549638 600222 477675 481459 496174 574493 601529 514808 565181 564383 611500 610255 601616 627383 609731 446369 490606 617134 439518 484958 550409 653537 436074 568072 609205 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (2.01%) |
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 236863 383326 391541 394764 395606 401321 411319 417978 418419 421071 422351 423301 425799 427113 429571 431546 432426 432448 432472 432476 432477 432507 432569 433571 433584 434077 434783 436074 437914 439518 441572 443372 446369 451089 455798 457059 465182 465905 469233 469698 469921 475134 475658 475847 477675 481459 483159 483652 484958 485701 490606 491174 491516 492063 492272 494805 494814 496174 496669 497193 498905 500146 500157 500186 500386 500429 505077 509669 511312 514808 515167 515565 518602 520703 521715 523150 524226 524522 526139 526345 526799 528035 528190 535063 547880 549622 549638 550409 552278 563155 564383 565181 567703 568072 568604 569622 569788 572631 574493 575123 581710 586563 594644 595252 596809 598233 600222 600898 601529 601616 602705 603829 609205 609731 610255 611500 617134 627383 653537 662567 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 голый"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 голый"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 голый"
]
|
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.