Query Metrics
7
Database Queries
7
Different statements
159.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.59 ms (82.01%) |
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 108208 166116 214988 382466 382649 382744 382942 383560 385476 385480 385829 386892 387830 388811 390889 391002 396485 397072 398018 402503 403918 410265 412952 416155 417799 418540 418706 419154 421346 422640 422641 422859 423019 423761 425366 428913 429547 429930 429949 430920 431672 446594 448346 452067 452530 456635 456862 460474 463747 468719 472669 472949 481376 499041 511260 512182 512763 520144 521752 525192 534198 535451 539946 540168 540176 550208 550214 552021 552040 552913 552931 554423 554789 556366 556375 557114 557206 559869 559876 559898 565211 577048 583667 586542 588060 589736 590925 596315 596519 614529 622200 622266 622540 634422 642442 643379 645571 673048 677581 680900 687021 695565 699602 727656 735387 735852 737900 740536 741935 748634 748639 748681 770273 770665 771830 771876 793934 813507 813659 ] |
||||||||||||||||||||||||||||||
|
18.04 ms (11.33%) |
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 446594 512763 770665 108208 403918 472669 429949 559876 554789 391002 552040 412952 388811 402503 460474 556366 396485 397072 590925 452067 643379 425366 539946 398018 428913 417799 748634 534198 385829 382942 520144 559869 431672 614529 418540 559898 421346 535451 429547 512182 552931 627735 390889 452530 468719 565211 385480 540176 622266 673048 382744 386892 540168 550208 550214 586542 622200 735387 699602 748681 740536 166116 525192 448346 456862 813507 416155 382466 511260 577048 589736 634422 622540 418706 382649 214988 687021 770273 552913 596315 463747 554423 695565 680900 748639 793934 481376 552021 741935 422640 499041 521752 556375 419154 813659 677581 727656 737900 771830 771876 423019 430920 456635 735852 557114 642442 588060 383560 429930 583667 422641 423761 422859 385476 410265 472949 387830 645571 557206 596519 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (2.15%) |
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 108208 166116 214988 382466 382649 382744 382942 383560 385476 385480 385829 386892 387830 388811 390889 391002 396485 397072 398018 402503 403918 410265 412952 416155 417799 418540 418706 419154 421346 422640 422641 422859 423019 423761 425366 428913 429547 429930 429949 430920 431672 446594 448346 452067 452530 456635 456862 460474 463747 468719 472669 472949 481376 499041 511260 512182 512763 520144 521752 525192 534198 535451 539946 540168 540176 550208 550214 552021 552040 552913 552931 554423 554789 556366 556375 557114 557206 559869 559876 559898 565211 577048 583667 586542 588060 589736 590925 596315 596519 614529 622200 622266 622540 634422 642442 643379 645571 673048 677581 680900 687021 695565 699602 727656 735387 735852 737900 740536 741935 748634 748639 748681 770273 770665 771830 771876 793934 813507 813659 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob asian"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.