Query Metrics
7
Database Queries
7
Different statements
161.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.95 ms (81.10%) |
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 390565 405537 408974 409774 413740 420083 421050 421196 423418 428394 430336 430368 430709 438725 438762 442441 444753 446165 446589 458433 462209 464664 469070 470247 471365 473102 475199 477895 486451 486470 490762 495317 496270 499446 501710 504260 504840 506259 507524 512036 512213 513876 513901 514404 515167 515189 517577 518255 518540 523711 530057 530268 530771 531208 533463 534386 534987 536636 536638 537209 537890 537932 540186 541076 546641 549786 550452 551273 552120 557985 558417 558614 560551 561334 561351 562893 564808 565264 565984 566035 567304 567329 567863 567907 568038 569413 576529 579301 581682 582841 588745 591143 591331 595798 598106 599888 608756 614995 624122 624430 631193 633446 635220 638967 640805 641698 643318 644940 645999 661281 679038 679721 679821 716030 718525 738440 748210 771845 775814 824469 ] |
||||||||||||||||||||||||||||||
|
20.33 ms (12.59%) |
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 512213 537890 643318 775814 771845 408974 523711 507524 558417 568038 551273 518540 515189 644940 536636 530057 679038 679821 718525 475199 420083 423418 515167 495317 504260 444753 824469 486470 458433 486451 540186 537932 562893 645999 748210 446589 413740 513876 446165 560551 582841 661281 565264 591331 591143 738440 421196 421050 438762 430336 405537 512036 469070 534386 679721 598106 442441 581682 716030 561351 552120 567329 564808 567863 567304 518255 533463 530268 546641 588745 438725 477895 390565 534987 537209 631193 506259 430368 409774 428394 531208 530771 549786 595798 561334 558614 569413 462209 550452 635220 430709 640805 471365 517577 499446 464664 513901 514404 567907 565984 490762 541076 624122 536638 633446 566035 496270 473102 576529 579301 641698 614995 624430 557985 470247 599888 504840 638967 608756 501710 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.79%) |
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 390565 405537 408974 409774 413740 420083 421050 421196 423418 428394 430336 430368 430709 438725 438762 442441 444753 446165 446589 458433 462209 464664 469070 470247 471365 473102 475199 477895 486451 486470 490762 495317 496270 499446 501710 504260 504840 506259 507524 512036 512213 513876 513901 514404 515167 515189 517577 518255 518540 523711 530057 530268 530771 531208 533463 534386 534987 536636 536638 537209 537890 537932 540186 541076 546641 549786 550452 551273 552120 557985 558417 558614 560551 561334 561351 562893 564808 565264 565984 566035 567304 567329 567863 567907 568038 569413 576529 579301 581682 582841 588745 591143 591331 595798 598106 599888 608756 614995 624122 624430 631193 633446 635220 638967 640805 641698 643318 644940 645999 661281 679038 679721 679821 716030 718525 738440 748210 771845 775814 824469 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"three girls"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"three девушк"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"three девушк"
]
|
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.