Query Metrics
7
Database Queries
7
Different statements
148.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.90 ms (83.21%) |
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 390257 398686 407176 417238 424284 424720 427655 429911 436900 438296 438984 445355 446525 450656 452290 452688 454030 455182 455488 455540 455976 457328 459138 459210 459354 459645 459755 459887 461318 463701 464068 464780 465232 468112 469492 470990 473315 475148 475777 475818 479918 480835 486808 488744 497125 501367 506707 526887 537164 545046 554680 558725 563682 576167 577281 583795 596450 600690 615494 618760 619570 626041 626659 628591 628602 629660 640937 651690 652757 660032 660454 663747 667427 668097 670189 676205 687535 688166 695444 705201 706077 709620 710173 723239 724086 728094 732525 734708 739802 739821 745269 748282 749930 753621 765194 765636 767651 777751 777757 777761 777764 777766 777768 780331 781011 786836 790708 791419 792195 794072 794471 797050 800175 801841 802407 807588 810581 814398 819808 824164 ] |
||||||||||||||||||||||||||||||
|
14.92 ms (10.02%) |
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 417238 424720 429911 424284 438296 445355 819808 814398 824164 446525 457328 469492 475148 479918 488744 452290 452688 454030 455540 459210 459755 450656 455976 459138 459645 463701 468112 470990 480835 486808 497125 501367 537164 526887 506707 461318 577281 583795 563682 652757 670189 688166 695444 710173 651690 660032 687535 705201 706077 723239 660454 663747 667427 668097 676205 545046 554680 558725 576167 626659 628602 600690 628591 640937 596450 629660 619570 626041 777766 786836 800175 801841 802407 777751 777757 777764 777768 781011 790708 792195 810581 765194 791419 794471 728094 732525 724086 767651 739821 745269 748282 753621 734708 739802 749930 765636 615494 618760 709620 777761 780331 794072 797050 807588 407176 464780 473315 475777 475818 464068 398686 427655 436900 438984 455182 455488 459354 459887 465232 390257 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.83%) |
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 390257 398686 407176 417238 424284 424720 427655 429911 436900 438296 438984 445355 446525 450656 452290 452688 454030 455182 455488 455540 455976 457328 459138 459210 459354 459645 459755 459887 461318 463701 464068 464780 465232 468112 469492 470990 473315 475148 475777 475818 479918 480835 486808 488744 497125 501367 506707 526887 537164 545046 554680 558725 563682 576167 577281 583795 596450 600690 615494 618760 619570 626041 626659 628591 628602 629660 640937 651690 652757 660032 660454 663747 667427 668097 670189 676205 687535 688166 695444 705201 706077 709620 710173 723239 724086 728094 732525 734708 739802 739821 745269 748282 749930 753621 765194 765636 767651 777751 777757 777761 777764 777766 777768 780331 781011 786836 790708 791419 792195 794072 794471 797050 800175 801841 802407 807588 810581 814398 819808 824164 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"gorgeous wife"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"шикарная жен"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"шикарная жен"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.