Query Metrics
7
Database Queries
7
Different statements
147.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.33 ms (82.37%) |
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 326290 406070 417460 432716 439028 439727 441611 447662 447819 447970 448524 449083 450338 456699 461711 464903 470053 470446 471458 474749 476806 478256 484424 486213 487682 493256 494384 497443 497647 503448 506501 511015 517038 533384 535528 536419 542217 543129 544190 551962 553472 556013 558655 562105 564354 568477 568524 569573 574360 574970 575780 581246 585726 589487 594340 597632 598493 598874 599778 600358 600418 614927 618846 624484 624895 626282 626401 628028 628500 632087 633316 634536 637133 651873 663224 666736 669001 672946 673223 680472 686002 687583 692718 693356 693494 695464 695892 695908 700295 702162 704215 705404 707089 708865 710424 712697 722583 726960 727739 730350 733846 733882 742360 761031 761496 761600 778949 785051 787155 788133 790575 791160 791270 791580 791809 796879 797065 803485 807510 813399 ] |
||||||||||||||||||||||||||||||
|
16.25 ms (11.03%) |
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 493256 447819 461711 474749 470053 471458 487682 497647 511015 533384 535528 497443 506501 517038 503448 536419 464903 484424 574360 581246 551962 568477 568524 542217 543129 564354 666736 695908 712697 693494 695464 702162 705404 708865 710424 669001 680472 687583 692718 704215 556013 575780 589487 598493 598874 626401 628500 632087 624895 637133 594340 597632 599778 600358 614927 634536 600418 633316 787155 788133 796879 778949 785051 791160 791270 791580 761600 733882 742360 761031 726960 730350 761496 727739 733846 618846 626282 790575 791809 797065 803485 807510 439727 476806 417460 439028 470446 441611 450338 486213 624484 628028 813399 326290 406070 432716 449083 456699 447662 478256 447970 448524 494384 553472 558655 562105 574970 544190 686002 695892 700295 707089 663224 673223 693356 651873 672946 722583 569573 585726 ] |
||||||||||||||||||||||||||||||
|
2.76 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 326290 406070 417460 432716 439028 439727 441611 447662 447819 447970 448524 449083 450338 456699 461711 464903 470053 470446 471458 474749 476806 478256 484424 486213 487682 493256 494384 497443 497647 503448 506501 511015 517038 533384 535528 536419 542217 543129 544190 551962 553472 556013 558655 562105 564354 568477 568524 569573 574360 574970 575780 581246 585726 589487 594340 597632 598493 598874 599778 600358 600418 614927 618846 624484 624895 626282 626401 628028 628500 632087 633316 634536 637133 651873 663224 666736 669001 672946 673223 680472 686002 687583 692718 693356 693494 695464 695892 695908 700295 702162 704215 705404 707089 708865 710424 712697 722583 726960 727739 730350 733846 733882 742360 761031 761496 761600 778949 785051 787155 788133 790575 791160 791270 791580 791809 796879 797065 803485 807510 813399 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal hair"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал hair"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал hair"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.98%) |
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.