Query Metrics
7
Database Queries
7
Different statements
181.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.43 ms (82.99%) |
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 385278 393442 409484 415961 419197 426361 439033 439463 440361 440469 440481 440826 441049 443572 444283 444842 445211 446445 446863 446948 449210 450434 452760 454526 456232 461651 461673 465814 470392 471635 472159 478665 479590 480960 482725 483123 485803 486312 486596 486619 487191 488152 488827 490819 493490 493897 494493 499143 499765 503003 508107 508542 508895 510214 510565 512972 513547 514236 514272 517182 517780 518798 520487 521600 522440 526356 527072 527355 527660 531632 533937 534553 535091 537966 552745 554256 558568 558645 560508 560663 564132 565033 566086 567272 570718 571812 575852 579624 585142 585173 586641 588818 590813 594503 595687 597920 598078 599713 600607 600804 604238 604328 610958 612414 626569 628910 641764 641910 648716 659215 671396 672906 674507 679821 720184 740920 747655 747687 755331 792423 ] |
||||||||||||||||||||||||||||||
|
20.56 ms (11.34%) |
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 514272 488152 493897 595687 612414 385278 594503 598078 628910 604238 600607 626569 499143 571812 672906 599713 426361 439463 440826 585142 482725 470392 486619 494493 531632 533937 534553 517182 521600 483123 488827 560508 565033 552745 554256 558568 720184 648716 558645 564132 567272 585173 604328 740920 747687 465814 446863 452760 415961 445211 485803 486312 747655 755331 517780 444283 440481 493490 450434 508542 510565 522440 526356 472159 575852 674507 560663 586641 600804 792423 446445 480960 446948 440361 444842 478665 479590 439033 486596 487191 490819 512972 514236 520487 659215 597920 588818 641910 641764 393442 409484 570718 671396 508107 535091 499765 441049 449210 461673 537966 527072 566086 579624 679821 590813 610958 471635 510214 513547 518798 503003 527660 527355 419197 440469 443572 456232 454526 508895 461651 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.87%) |
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 385278 393442 409484 415961 419197 426361 439033 439463 440361 440469 440481 440826 441049 443572 444283 444842 445211 446445 446863 446948 449210 450434 452760 454526 456232 461651 461673 465814 470392 471635 472159 478665 479590 480960 482725 483123 485803 486312 486596 486619 487191 488152 488827 490819 493490 493897 494493 499143 499765 503003 508107 508542 508895 510214 510565 512972 513547 514236 514272 517182 517780 518798 520487 521600 522440 526356 527072 527355 527660 531632 533937 534553 535091 537966 552745 554256 558568 558645 560508 560663 564132 565033 566086 567272 570718 571812 575852 579624 585142 585173 586641 588818 590813 594503 595687 597920 598078 599713 600607 600804 604238 604328 610958 612414 626569 628910 641764 641910 648716 659215 671396 672906 674507 679821 720184 740920 747655 747687 755331 792423 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade petite"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск petite"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск petite"
]
|
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.