Query Metrics
7
Database Queries
7
Different statements
163.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.12 ms (82.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 383616 395620 400995 403588 404292 406298 411696 413524 413889 415568 416867 426203 427362 439616 439757 442805 443179 443733 444465 445543 446684 447490 449021 453099 455922 460731 462315 462470 465353 467389 469595 470288 472941 474095 475194 475889 481149 486590 487917 489263 490409 490822 490894 498047 499423 502749 504841 506050 506052 511250 512339 513474 513480 513503 513518 516709 517386 518948 519157 519553 523023 523335 524361 524370 524371 524388 524896 524931 528146 528448 540794 540802 540803 549638 551299 557128 557592 560152 560430 562894 568079 577331 577409 579113 580391 580860 586806 595873 597831 598890 601828 605383 606508 606571 612335 612381 618399 619508 619516 619526 622402 624734 628989 629296 635222 640695 642691 644748 651038 665314 687924 714511 748244 789690 801907 803095 804531 808526 815268 815600 ] |
||||||||||||||||||||||||||||||
|
18.41 ms (11.28%) |
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 560430 651038 665314 580391 586806 803095 748244 413524 427362 443179 446684 467389 502749 499423 506050 513503 523023 395620 447490 487917 518948 557128 560152 568079 640695 644748 601828 804531 444465 413889 513474 462470 595873 622402 528448 524388 404292 528146 577409 714511 629296 606571 475194 416867 516709 411696 443733 815600 453099 475889 635222 598890 618399 619508 789690 400995 403588 439616 439757 426203 442805 465353 460731 511250 490894 513518 524371 540802 540803 540794 486590 524370 449021 606508 642691 519157 519553 580860 687924 624734 605383 808526 481149 628989 524931 445543 415568 474095 506052 549638 557592 612335 619516 619526 815268 472941 470288 524896 512339 383616 612381 462315 455922 406298 489263 513480 490409 577331 579113 597831 801907 517386 523335 504841 562894 551299 498047 469595 524361 490822 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.81%) |
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 383616 395620 400995 403588 404292 406298 411696 413524 413889 415568 416867 426203 427362 439616 439757 442805 443179 443733 444465 445543 446684 447490 449021 453099 455922 460731 462315 462470 465353 467389 469595 470288 472941 474095 475194 475889 481149 486590 487917 489263 490409 490822 490894 498047 499423 502749 504841 506050 506052 511250 512339 513474 513480 513503 513518 516709 517386 518948 519157 519553 523023 523335 524361 524370 524371 524388 524896 524931 528146 528448 540794 540802 540803 549638 551299 557128 557592 560152 560430 562894 568079 577331 577409 579113 580391 580860 586806 595873 597831 598890 601828 605383 606508 606571 612335 612381 618399 619508 619516 619526 622402 624734 628989 629296 635222 640695 642691 644748 651038 665314 687924 714511 748244 789690 801907 803095 804531 808526 815268 815600 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old sexy 18"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old sexy 18"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old sexy 18"
]
|
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.