Query Metrics
7
Database Queries
7
Different statements
174.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.08 ms (83.66%) |
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 47583 418895 419173 420680 422967 426873 427003 430343 432990 443215 446510 447273 455967 455975 455978 455981 458614 461333 463341 471533 472567 477399 480977 482478 483551 493034 493423 494059 497317 497656 497935 502779 503026 503029 503043 511677 515968 517278 524373 527119 528635 529319 539858 542676 546099 546865 551952 552737 557361 557579 567574 568629 571812 577767 578295 580053 581185 582931 584079 584336 584535 584610 587523 588577 591637 591748 595236 600132 600579 600610 600805 600818 602575 603929 606396 616637 619125 626432 629667 631214 638633 638894 640240 644595 645665 645667 665906 668459 671152 677171 683357 703248 708263 712276 732211 734637 751842 754168 754865 756279 756868 785711 790045 790884 801890 802111 810176 810549 812083 812882 813803 815096 815137 819177 820871 821370 821605 822844 823419 823818 ] |
||||||||||||||||||||||||||||||
|
17.82 ms (10.20%) |
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 812083 815137 430343 820871 821370 821605 528635 790884 443215 551952 483551 515968 527119 557579 683357 671152 677171 640240 600818 812882 802111 446510 542676 472567 819177 813803 493423 645667 629667 616637 644595 427003 822844 539858 552737 645665 665906 801890 756868 754865 502779 503029 584336 480977 815096 419173 703248 823419 584079 582931 600805 587523 606396 751842 790045 810549 47583 503026 591637 458614 482478 567574 493034 577767 810176 602575 503043 494059 497935 471533 712276 546099 546865 603929 588577 631214 785711 756279 463341 461333 732211 734637 418895 568629 580053 584535 668459 708263 581185 638633 591748 595236 619125 638894 626432 426873 529319 497317 517278 524373 455967 455981 447273 497656 578295 584610 600610 455978 477399 455975 571812 557361 600132 600579 754168 422967 420680 432990 511677 823818 ] |
||||||||||||||||||||||||||||||
|
3.63 ms (2.08%) |
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 47583 418895 419173 420680 422967 426873 427003 430343 432990 443215 446510 447273 455967 455975 455978 455981 458614 461333 463341 471533 472567 477399 480977 482478 483551 493034 493423 494059 497317 497656 497935 502779 503026 503029 503043 511677 515968 517278 524373 527119 528635 529319 539858 542676 546099 546865 551952 552737 557361 557579 567574 568629 571812 577767 578295 580053 581185 582931 584079 584336 584535 584610 587523 588577 591637 591748 595236 600132 600579 600610 600805 600818 602575 603929 606396 616637 619125 626432 629667 631214 638633 638894 640240 644595 645665 645667 665906 668459 671152 677171 683357 703248 708263 712276 732211 734637 751842 754168 754865 756279 756868 785711 790045 790884 801890 802111 810176 810549 812083 812882 813803 815096 815137 819177 820871 821370 821605 822844 823419 823818 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"asian pov"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"азиатк пов"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.91%) |
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.