Query Metrics
7
Database Queries
7
Different statements
189.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.69 ms (81.53%) |
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 29292 56805 69876 90460 191069 197389 204849 314006 382097 382296 382488 396781 397014 397249 400439 401364 402550 405125 413115 413223 414621 419794 420331 421219 423239 430858 431647 442367 445024 471847 472499 478638 483243 484415 484434 484500 488101 489370 489455 489566 489820 489970 491704 492707 493469 494040 495982 496856 498349 498936 502124 508743 510048 510806 510976 511738 512287 513004 513267 513860 515835 518739 519742 520327 520512 521017 521879 521906 522970 523330 525817 526361 528176 528268 535632 538739 547775 552194 556988 561996 562328 569511 570435 573572 582484 582852 593285 600895 607150 626730 650951 653239 670461 675551 688483 691584 701452 702330 704211 716099 722225 723750 734348 735036 736639 737252 739028 739312 746708 746934 748437 756371 770570 777795 788263 791018 794060 806870 809323 814033 ] |
||||||||||||||||||||||||||||||
|
23.72 ms (12.50%) |
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 515835 519742 521879 523330 528176 484434 489370 489455 489820 491704 495982 510806 510976 512287 513004 521906 522970 525817 483243 484500 489566 493469 494040 498349 498936 502124 510048 511738 513860 520512 484415 488101 489970 492707 508743 513267 521017 535632 69876 204849 314006 382296 402550 538739 471847 650951 704211 691584 561996 593285 600895 735036 739312 723750 736639 746708 748437 770570 809323 56805 413223 29292 401364 397014 191069 397249 382488 90460 419794 582852 675551 756371 788263 382097 197389 405125 421219 442367 472499 478638 414621 420331 496856 518739 528268 520327 607150 526361 701452 688483 734348 737252 739028 746934 423239 445024 413115 814033 570435 569511 653239 670461 702330 716099 722225 547775 552194 556988 562328 573572 582484 626730 777795 791018 794060 806870 396781 400439 430858 431647 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (1.85%) |
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 29292 56805 69876 90460 191069 197389 204849 314006 382097 382296 382488 396781 397014 397249 400439 401364 402550 405125 413115 413223 414621 419794 420331 421219 423239 430858 431647 442367 445024 471847 472499 478638 483243 484415 484434 484500 488101 489370 489455 489566 489820 489970 491704 492707 493469 494040 495982 496856 498349 498936 502124 508743 510048 510806 510976 511738 512287 513004 513267 513860 515835 518739 519742 520327 520512 521017 521879 521906 522970 523330 525817 526361 528176 528268 535632 538739 547775 552194 556988 561996 562328 569511 570435 573572 582484 582852 593285 600895 607150 626730 650951 653239 670461 675551 688483 691584 701452 702330 704211 716099 722225 723750 734348 735036 736639 737252 739028 739312 746708 746934 748437 756371 770570 777795 788263 791018 794060 806870 809323 814033 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие красивая"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big this beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие красивая"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.