Query Metrics
7
Database Queries
7
Different statements
411.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.10 ms (51.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teen cock"
]
|
||||||||||||||||||||||||||||||
|
175.62 ms (42.65%) |
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 394154 395306 402735 414201 416898 417448 420462 424386 429323 429384 429385 434709 434767 441567 443489 444928 445851 447137 448657 453663 454532 454842 456214 456567 457955 459237 460343 465874 469613 470273 473774 476084 477543 479973 489888 496750 497448 499134 504672 521182 521837 523197 526259 527589 529061 537960 542245 545204 560261 568048 572028 575665 581229 589185 592544 594289 594440 594463 594531 595367 595549 595579 598012 598448 603951 606357 610346 612240 612441 618200 623968 624617 626254 626256 631020 634954 635704 638193 638752 644617 647402 648332 659329 660330 662220 664082 664437 665714 665916 666364 670649 682320 684630 684902 697609 700470 700855 703324 707076 711532 715338 715575 715734 720079 722519 732262 756319 762568 777646 778393 784742 791975 796170 796719 798992 800305 812432 818798 825542 826672 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (3.78%) |
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 644617 529061 659329 818798 526259 682320 537960 434709 441567 429323 826672 479973 454532 473774 545204 572028 662220 664437 715338 720079 626254 589185 594531 595367 612240 777646 784742 756319 778393 434767 456214 476084 521837 429385 499134 504672 581229 722519 762568 798992 447137 465874 700470 594463 477543 457955 631020 395306 420462 606357 560261 660330 666364 684902 664082 598012 612441 595549 598448 610346 592544 595579 665714 542245 670649 648332 684630 703324 647402 697609 568048 635704 638193 624617 638752 715734 825542 394154 424386 429384 453663 497448 521182 496750 700855 623968 791975 732262 796719 800305 715575 402735 444928 443489 416898 470273 417448 456567 460343 489888 459237 523197 603951 454842 414201 445851 448657 575665 665916 626256 527589 796170 812432 469613 707076 618200 634954 711532 594289 594440 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (0.73%) |
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 394154 395306 402735 414201 416898 417448 420462 424386 429323 429384 429385 434709 434767 441567 443489 444928 445851 447137 448657 453663 454532 454842 456214 456567 457955 459237 460343 465874 469613 470273 473774 476084 477543 479973 489888 496750 497448 499134 504672 521182 521837 523197 526259 527589 529061 537960 542245 545204 560261 568048 572028 575665 581229 589185 592544 594289 594440 594463 594531 595367 595549 595579 598012 598448 603951 606357 610346 612240 612441 618200 623968 624617 626254 626256 631020 634954 635704 638193 638752 644617 647402 648332 659329 660330 662220 664082 664437 665714 665916 666364 670649 682320 684630 684902 697609 700470 700855 703324 707076 711532 715338 715575 715734 720079 722519 732262 756319 762568 777646 778393 784742 791975 796170 796719 798992 800305 812432 818798 825542 826672 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teen cock"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teen cock"
]
|
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.