Query Metrics
7
Database Queries
7
Different statements
157.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.25 ms (77.67%) |
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 263759 272725 382141 386928 388424 388460 388729 389144 398940 402626 403618 414137 416670 416683 420295 425895 426284 428246 429608 439378 444536 445945 446949 447151 448013 452988 457071 460208 465287 467986 469221 471682 481340 483315 483732 485280 488559 494325 495206 498915 507776 517509 519700 522174 522231 523058 525201 527217 527922 532830 535651 546854 553964 554550 569302 580355 584968 585251 585963 601071 605874 609888 613000 614967 617045 617604 618256 623606 624079 624739 624893 629602 639969 640331 654080 658907 669546 670782 680472 696141 702616 709214 712580 713162 728540 737895 743935 750881 751309 751410 751418 753163 754482 758785 774699 777016 777039 777847 781786 783036 783049 785589 795731 800658 801620 805120 806830 806929 807206 808580 808690 809039 811690 812480 812779 813558 817149 819256 825840 827399 ] |
||||||||||||||||||||||||||||||
|
25.17 ms (15.99%) |
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 580355 613000 585963 601071 639969 777039 728540 751418 751410 624893 808690 425895 494325 825840 654080 669546 702616 753163 445945 272725 444536 569302 754482 805120 624739 382141 498915 263759 428246 465287 471682 532830 517509 527217 519700 670782 680472 605874 614967 609888 777847 785589 800658 801620 808580 777016 812779 758785 750881 806929 481340 388424 448013 388460 460208 709214 388729 813558 525201 535651 712580 640331 617604 629602 624079 783036 806830 781786 795731 807206 751309 743935 386928 618256 416670 811690 457071 416683 426284 483732 584968 623606 469221 414137 402626 527922 658907 585251 488559 483315 827399 817149 696141 812480 737895 403618 819256 495206 554550 713162 485280 452988 507776 783049 389144 522231 522174 523058 553964 617045 439378 398940 446949 809039 774699 467986 546854 420295 429608 447151 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.77%) |
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 263759 272725 382141 386928 388424 388460 388729 389144 398940 402626 403618 414137 416670 416683 420295 425895 426284 428246 429608 439378 444536 445945 446949 447151 448013 452988 457071 460208 465287 467986 469221 471682 481340 483315 483732 485280 488559 494325 495206 498915 507776 517509 519700 522174 522231 523058 525201 527217 527922 532830 535651 546854 553964 554550 569302 580355 584968 585251 585963 601071 605874 609888 613000 614967 617045 617604 618256 623606 624079 624739 624893 629602 639969 640331 654080 658907 669546 670782 680472 696141 702616 709214 712580 713162 728540 737895 743935 750881 751309 751410 751418 753163 754482 758785 774699 777016 777039 777847 781786 783036 783049 785589 795731 800658 801620 805120 806830 806929 807206 808580 808690 809039 811690 812480 812779 813558 817149 819256 825840 827399 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dildo toys"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие дилд toys"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие дилд toys"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.92%) |
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.