Query Metrics
7
Database Queries
7
Different statements
144.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.08 ms (83.20%) |
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 388183 397509 401177 410242 410272 414094 414138 414256 416631 418077 419296 419816 430581 435027 437808 439062 446562 446641 447158 448588 449079 449108 452816 454754 454808 456608 463687 466455 468233 475414 476054 477169 479669 485031 487428 499934 510781 514248 515357 517928 518137 521677 523373 525281 526164 526498 532381 534023 541423 542708 547468 547488 547767 554949 557284 557343 557969 561970 569341 569359 571194 572777 574023 581058 582314 582339 583476 584351 584558 586407 587210 592333 594491 594534 595483 596857 605026 610193 620901 624811 633119 639326 648761 649586 652249 669080 679194 686807 700257 707840 714562 718772 740407 750426 751017 751452 758648 763724 782633 782804 785589 785871 788953 791916 795393 795655 796943 799580 802314 803524 805139 805355 805645 808988 811296 818532 819238 821877 823607 824121 ] |
||||||||||||||||||||||||||||||
|
15.19 ms (10.53%) |
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 574023 547767 596857 811296 763724 805139 515357 561970 547488 547468 649586 788953 446562 414138 514248 819238 821877 824121 818532 823607 479669 510781 532381 499934 526164 468233 477169 542708 557343 582339 571194 572777 541423 557284 583476 679194 686807 718772 652249 700257 569359 581058 582314 587210 610193 620901 594534 624811 782633 785589 799580 802314 795393 808988 758648 750426 751017 740407 751452 633119 714562 791916 796943 448588 414256 388183 454754 454808 463687 534023 410242 525281 447158 414094 439062 449079 456608 452816 485031 523373 557969 569341 554949 584558 586407 639326 397509 476054 419296 446641 401177 418077 466455 416631 419816 437808 487428 521677 526498 449108 707840 795655 805355 805645 435027 595483 410272 475414 517928 430581 518137 584351 648761 669080 592333 594491 605026 785871 782804 803524 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.57%) |
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 388183 397509 401177 410242 410272 414094 414138 414256 416631 418077 419296 419816 430581 435027 437808 439062 446562 446641 447158 448588 449079 449108 452816 454754 454808 456608 463687 466455 468233 475414 476054 477169 479669 485031 487428 499934 510781 514248 515357 517928 518137 521677 523373 525281 526164 526498 532381 534023 541423 542708 547468 547488 547767 554949 557284 557343 557969 561970 569341 569359 571194 572777 574023 581058 582314 582339 583476 584351 584558 586407 587210 592333 594491 594534 595483 596857 605026 610193 620901 624811 633119 639326 648761 649586 652249 669080 679194 686807 700257 707840 714562 718772 740407 750426 751017 751452 758648 763724 782633 782804 785589 785871 788953 791916 795393 795655 796943 799580 802314 803524 805139 805355 805645 808988 811296 818532 819238 821877 823607 824121 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty анал соло"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty анал соло"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty anal solo"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.09%) |
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.