Query Metrics
7
Database Queries
7
Different statements
154.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.45 ms (82.74%) |
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 391808 418141 420589 420680 425473 428382 428388 436040 442547 443986 450635 450657 450861 455514 455920 456660 458195 458348 458429 458433 460126 460531 460538 461006 461774 462258 462285 465071 467165 467735 469711 470826 472069 473508 473637 474489 475204 475207 476972 478756 479483 479511 480487 480894 482401 482489 484009 485347 486965 487133 489003 489187 489792 491695 491699 491720 493953 496976 497146 497199 498234 498899 499224 502180 503109 505421 506208 506946 508747 508836 510106 512399 512652 512769 513320 516250 519657 519665 521095 521298 521898 523666 527270 527314 527626 546340 547986 548316 552323 552353 554303 554563 554955 558505 560257 564096 566100 568392 568608 568666 569068 570910 571656 571983 573731 573783 584646 590573 594505 594979 597869 606321 620072 621937 635422 636264 645096 668005 716351 721967 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (10.09%) |
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 484009 497146 512769 523666 489792 493953 505421 482401 450657 461006 479483 428382 489003 508836 590573 450861 519657 391808 474489 465071 521898 467165 472069 460538 461774 418141 476972 480487 460531 473508 497199 503109 506208 513320 485347 491695 498234 527314 478756 460126 469711 458429 473637 554563 552323 571983 554303 443986 436040 487133 491699 527270 594979 594505 621937 552353 480894 482489 512399 564096 606321 597869 636264 470826 420589 450635 510106 506946 527626 425473 475204 496976 519665 458348 458433 462258 521095 498899 502180 546340 547986 558505 568666 569068 570910 571656 548316 560257 566100 568392 554955 568608 573731 584646 716351 645096 668005 573783 620072 635422 721967 456660 428388 455920 467735 479511 420680 455514 458195 462285 475207 442547 508747 516250 491720 512652 486965 489187 499224 521298 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.68%) |
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 391808 418141 420589 420680 425473 428382 428388 436040 442547 443986 450635 450657 450861 455514 455920 456660 458195 458348 458429 458433 460126 460531 460538 461006 461774 462258 462285 465071 467165 467735 469711 470826 472069 473508 473637 474489 475204 475207 476972 478756 479483 479511 480487 480894 482401 482489 484009 485347 486965 487133 489003 489187 489792 491695 491699 491720 493953 496976 497146 497199 498234 498899 499224 502180 503109 505421 506208 506946 508747 508836 510106 512399 512652 512769 513320 516250 519657 519665 521095 521298 521898 523666 527270 527314 527626 546340 547986 548316 552323 552353 554303 554563 554955 558505 560257 564096 566100 568392 568608 568666 569068 570910 571656 571983 573731 573783 584646 590573 594505 594979 597869 606321 620072 621937 635422 636264 645096 668005 716351 721967 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur pickup"
]
|
||||||||||||||||||||||||||||||
|
2.18 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск пикап"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.