Query Metrics
7
Database Queries
7
Different statements
166.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.66 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 4429 68412 382713 395310 398053 398475 422287 426334 426664 429492 432086 439373 444746 446800 452743 453339 454040 456365 456860 458104 459269 460850 461389 461922 463469 465559 466304 467584 469148 473375 484312 489840 494221 496120 497732 499305 503359 505589 506224 507568 510352 511015 514779 520152 530255 534011 538515 541576 542923 546373 547659 550154 559701 559783 561876 569471 572108 579847 581742 587885 589185 591619 592304 595138 595434 599539 601964 603650 607658 608160 612464 638357 650258 650692 662438 668493 673326 673398 695182 699338 703564 711542 717641 733555 736483 737445 737504 737877 743128 756302 758876 759747 760439 765083 766082 772421 773251 780033 780300 780810 784839 788423 788697 789109 795205 795250 797330 799042 800425 802949 808578 809403 809743 812660 813077 815784 817902 822851 823247 825874 ] |
||||||||||||||||||||||||||||||
|
15.80 ms (9.46%) |
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 703564 784839 797330 459269 426664 507568 514779 429492 822851 823247 825874 454040 458104 452743 505589 550154 579847 668493 673326 650258 673398 695182 650692 591619 592304 607658 612464 599539 780300 788697 802949 812660 780810 789109 809403 737504 765083 772421 809743 813077 733555 766082 756302 759747 736483 737877 795205 795250 456860 398475 460850 463469 446800 466304 395310 68412 4429 398053 422287 432086 817902 469148 534011 499305 465559 473375 569471 542923 572108 547659 559783 561876 581742 699338 711542 662438 587885 603650 589185 595434 608160 638357 595138 780033 800425 737445 743128 758876 760439 788423 773251 601964 717641 799042 808578 426334 461922 439373 510352 496120 489840 382713 444746 815784 453339 456365 484312 467584 497732 511015 520152 538515 494221 503359 506224 530255 461389 541576 546373 559701 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.90%) |
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 4429 68412 382713 395310 398053 398475 422287 426334 426664 429492 432086 439373 444746 446800 452743 453339 454040 456365 456860 458104 459269 460850 461389 461922 463469 465559 466304 467584 469148 473375 484312 489840 494221 496120 497732 499305 503359 505589 506224 507568 510352 511015 514779 520152 530255 534011 538515 541576 542923 546373 547659 550154 559701 559783 561876 569471 572108 579847 581742 587885 589185 591619 592304 595138 595434 599539 601964 603650 607658 608160 612464 638357 650258 650692 662438 668493 673326 673398 695182 699338 703564 711542 717641 733555 736483 737445 737504 737877 743128 756302 758876 759747 760439 765083 766082 772421 773251 780033 780300 780810 784839 788423 788697 789109 795205 795250 797330 799042 800425 802949 808578 809403 809743 812660 813077 815784 817902 822851 823247 825874 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls out"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк out"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк out"
]
|
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.