Query Metrics
7
Database Queries
7
Different statements
216.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.09 ms (85.83%) |
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 114756 381921 382820 384433 387599 396218 396707 397643 399445 402447 404353 404710 405042 409100 409390 411025 411459 413444 413824 415520 416847 419386 420241 420541 422546 422609 422631 423007 423039 423095 424129 424317 428055 430239 430300 430469 430561 435449 437059 441095 445397 445666 450023 454790 458302 458610 459170 459802 459803 460533 462450 463750 463753 463920 463987 464096 466780 468638 468688 470580 472746 474041 480687 482188 486273 487459 488858 492111 493172 493953 495235 495507 497934 500581 501557 503291 507351 507368 507375 507945 508538 511466 512023 512692 515452 516946 517936 519285 520468 520566 522844 527416 527705 528544 528836 558191 604364 616787 623519 624227 631504 636555 730098 730254 730728 731810 731866 732312 743134 752126 757157 758615 760936 760938 787616 807187 807301 809228 809361 811611 ] |
||||||||||||||||||||||||||||||
|
20.25 ms (9.34%) |
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 730254 731866 760936 730098 731810 732312 743134 752126 760938 730728 757157 758615 623519 624227 636555 787616 807187 807301 809228 809361 811611 409100 424129 424317 437059 445397 445666 463753 472746 474041 482188 387599 409390 420241 428055 450023 458610 459802 463750 463920 463987 114756 396218 399445 402447 404353 404710 405042 413824 454790 468688 397643 411025 458302 459170 459803 466780 480687 430239 430300 460533 464096 468638 470580 507351 507368 511466 515452 522844 487459 495507 512023 520566 527705 486273 488858 495235 501557 507375 512692 517936 520468 528836 493172 493953 497934 503291 507945 516946 528544 420541 631504 462450 492111 558191 430561 616787 604364 435449 500581 527416 508538 519285 382820 384433 381921 396707 411459 413444 419386 422631 423007 423039 423095 430469 441095 422609 416847 422546 415520 ] |
||||||||||||||||||||||||||||||
|
3.96 ms (1.82%) |
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 114756 381921 382820 384433 387599 396218 396707 397643 399445 402447 404353 404710 405042 409100 409390 411025 411459 413444 413824 415520 416847 419386 420241 420541 422546 422609 422631 423007 423039 423095 424129 424317 428055 430239 430300 430469 430561 435449 437059 441095 445397 445666 450023 454790 458302 458610 459170 459802 459803 460533 462450 463750 463753 463920 463987 464096 466780 468638 468688 470580 472746 474041 480687 482188 486273 487459 488858 492111 493172 493953 495235 495507 497934 500581 501557 503291 507351 507368 507375 507945 508538 511466 512023 512692 515452 516946 517936 519285 520468 520566 522844 527416 527705 528544 528836 558191 604364 616787 623519 624227 631504 636555 730098 730254 730728 731810 731866 732312 743134 752126 757157 758615 760936 760938 787616 807187 807301 809228 809361 811611 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"toys мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"toys man"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"toys мужчин"
]
|
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.