Query Metrics
7
Database Queries
7
Different statements
167.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.19 ms (85.42%) |
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 382604 384795 386535 411802 411818 411975 414659 420478 421169 428115 430310 431120 438570 443427 444386 444652 445639 453122 453439 453577 453804 454097 454328 454591 454882 464945 465660 468638 469195 472697 474752 475286 477120 480390 480829 482671 483497 486929 489270 489288 492385 492398 495725 499144 504564 506664 509487 512735 514710 517814 530372 531188 531296 532752 535467 536632 540508 542212 543487 543867 544848 545217 550379 576637 577696 583985 588262 591357 593750 598098 598438 599872 600269 601008 601593 601714 603773 604905 605066 605118 606192 606560 606635 607371 608035 621067 621434 630857 634121 634209 634849 634873 636053 643263 644941 644960 647665 648819 649560 651082 668537 691598 693532 696192 702619 705404 705677 710500 712010 714730 716175 718558 726662 726864 727597 729565 741541 750461 775911 776600 ] |
||||||||||||||||||||||||||||||
|
15.89 ms (9.48%) |
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 550379 705677 634121 621067 411802 474752 420478 506664 599872 702619 710500 504564 606560 741541 531296 530372 648819 634849 535467 532752 543487 544848 651082 712010 601714 588262 606635 634209 593750 454882 514710 499144 517814 509487 649560 598438 606192 634873 603773 729565 726662 472697 428115 444386 644960 453122 453804 454097 480390 489288 536632 576637 705404 604905 601008 607371 714730 483497 438570 480829 492385 716175 696192 718558 776600 727597 421169 492398 386535 453577 489270 445639 605066 384795 431120 443427 430310 482671 464945 726864 598098 465660 454328 454591 453439 475286 382604 444652 644941 647665 636053 750461 495725 468638 531188 583985 600269 608035 775911 411975 414659 540508 545217 542212 543867 691598 693532 591357 630857 605118 601593 411818 486929 512735 577696 668537 643263 621434 469195 477120 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.34%) |
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 382604 384795 386535 411802 411818 411975 414659 420478 421169 428115 430310 431120 438570 443427 444386 444652 445639 453122 453439 453577 453804 454097 454328 454591 454882 464945 465660 468638 469195 472697 474752 475286 477120 480390 480829 482671 483497 486929 489270 489288 492385 492398 495725 499144 504564 506664 509487 512735 514710 517814 530372 531188 531296 532752 535467 536632 540508 542212 543487 543867 544848 545217 550379 576637 577696 583985 588262 591357 593750 598098 598438 599872 600269 601008 601593 601714 603773 604905 605066 605118 606192 606560 606635 607371 608035 621067 621434 630857 634121 634209 634849 634873 636053 643263 644941 644960 647665 648819 649560 651082 668537 691598 693532 696192 702619 705404 705677 710500 712010 714730 716175 718558 726662 726864 727597 729565 741541 750461 775911 776600 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кастинг отсос"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.73%) |
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.