Query Metrics
7
Database Queries
7
Different statements
165.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.83 ms (84.27%) |
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 391079 395137 397008 400233 401640 404289 407597 407816 409904 411245 411342 413651 415306 415572 422053 422183 422587 425999 428472 431126 439685 439719 439737 439739 443179 443708 443757 444138 444869 446286 446624 451520 451826 451928 453679 454249 456429 458923 459919 460601 460745 461598 462106 462694 464960 465585 466085 466087 466979 467045 467055 467279 467389 467483 467843 470765 470966 471396 471494 474029 474785 475198 479047 479115 479333 481930 481933 482323 482325 482665 484375 484409 484596 484621 485773 486252 486471 488366 488439 490177 490188 490191 491322 500686 502617 502929 507659 508308 509488 510599 514724 514811 516562 522690 523226 528621 546117 546623 547607 547930 552029 552080 560123 562891 565313 569305 576338 580647 591046 606948 608358 609271 611986 620040 620054 620264 627806 636268 657402 675637 ] |
||||||||||||||||||||||||||||||
|
16.74 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 547930 675637 560123 569305 591046 620054 609271 422183 443708 453679 462106 462694 481930 404289 411342 465585 467279 467483 471396 479047 482323 482325 439719 444138 479115 479333 481933 397008 428472 439685 443757 460601 461598 474029 456429 466087 516562 490191 491322 502929 484621 466979 608358 522690 552029 657402 606948 636268 611986 627806 451928 407597 411245 471494 395137 391079 400233 409904 431126 413651 425999 485773 490188 470966 446286 482665 488366 514724 510599 523226 459919 467843 565313 546117 547607 580647 552080 562891 576338 546623 620040 620264 415306 415572 422053 443179 444869 460745 475198 439737 467055 470765 401640 439739 467389 451520 454249 466085 467045 508308 484409 486471 488439 490177 502617 509488 484375 484596 486252 500686 507659 514811 528621 407816 422587 446624 451826 458923 464960 474785 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.64%) |
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 391079 395137 397008 400233 401640 404289 407597 407816 409904 411245 411342 413651 415306 415572 422053 422183 422587 425999 428472 431126 439685 439719 439737 439739 443179 443708 443757 444138 444869 446286 446624 451520 451826 451928 453679 454249 456429 458923 459919 460601 460745 461598 462106 462694 464960 465585 466085 466087 466979 467045 467055 467279 467389 467483 467843 470765 470966 471396 471494 474029 474785 475198 479047 479115 479333 481930 481933 482323 482325 482665 484375 484409 484596 484621 485773 486252 486471 488366 488439 490177 490188 490191 491322 500686 502617 502929 507659 508308 509488 510599 514724 514811 516562 522690 523226 528621 546117 546623 547607 547930 552029 552080 560123 562891 565313 569305 576338 580647 591046 606948 608358 609271 611986 620040 620054 620264 627806 636268 657402 675637 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young kitchen"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young кухн"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young кухн"
]
|
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.