Query Metrics
7
Database Queries
7
Different statements
179.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.71 ms (78.18%) |
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 392023 399857 404746 408085 413818 413993 419677 420352 434045 435069 442239 443533 446166 446639 448074 449019 452080 452228 452370 460697 461424 463762 463840 464727 466445 468048 468517 470392 470840 474909 475870 477025 477224 478568 478702 479015 482936 487418 489097 494291 500194 500298 507408 507915 508519 510573 511606 514830 518282 518391 521173 521810 522210 522722 523798 525398 525844 527442 528409 528800 536903 549727 551407 552706 553833 553949 555269 555429 556121 556529 556967 557776 564604 566843 567863 569450 569960 570592 570878 573749 574450 574685 575451 576776 579858 583418 587152 592921 595516 596330 598564 601176 601387 605255 605794 620419 621165 621737 623291 627419 631083 645270 655437 655736 689978 715289 726654 751435 757319 765399 775182 785572 798243 798680 803039 805983 808077 808327 810701 814119 ] |
||||||||||||||||||||||||||||||
|
23.49 ms (13.05%) |
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 528800 408085 419677 434045 814119 446166 478702 449019 470392 478568 500194 507408 510573 500298 487418 549727 556967 575451 576776 579858 552706 557776 573749 715289 689978 553833 556121 564604 566843 583418 592921 605255 623291 631083 621165 627419 798680 803039 805983 810701 775182 798243 765399 757319 726654 751435 392023 475870 477224 452370 435069 460697 470840 479015 518391 511606 522722 525844 523798 463840 474909 482936 477025 507915 508519 518282 522210 574685 645270 655736 596330 605794 620419 601176 621737 595516 808327 785572 808077 448074 461424 399857 404746 446639 443533 468517 413818 466445 413993 452080 452228 463762 468048 528409 525398 514830 521173 556529 569450 570878 569960 574450 567863 655437 555269 587152 598564 601387 442239 464727 420352 527442 489097 494291 536903 521810 555429 570592 551407 553949 ] |
||||||||||||||||||||||||||||||
|
8.11 ms (4.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сильно возбудился и к%…"
]
|
||||||||||||||||||||||||||||||
|
2.91 ms (1.62%) |
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 392023 399857 404746 408085 413818 413993 419677 420352 434045 435069 442239 443533 446166 446639 448074 449019 452080 452228 452370 460697 461424 463762 463840 464727 466445 468048 468517 470392 470840 474909 475870 477025 477224 478568 478702 479015 482936 487418 489097 494291 500194 500298 507408 507915 508519 510573 511606 514830 518282 518391 521173 521810 522210 522722 523798 525398 525844 527442 528409 528800 536903 549727 551407 552706 553833 553949 555269 555429 556121 556529 556967 557776 564604 566843 567863 569450 569960 570592 570878 573749 574450 574685 575451 576776 579858 583418 587152 592921 595516 596330 598564 601176 601387 605255 605794 620419 621165 621737 623291 627419 631083 645270 655437 655736 689978 715289 726654 751435 757319 765399 775182 785572 798243 798680 803039 805983 808077 808327 810701 814119 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сильн"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.75%) |
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.