Query Metrics
7
Database Queries
7
Different statements
136.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
111.90 ms (82.17%) |
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 191179 389482 395306 396740 397508 397766 400465 402792 405897 408644 412332 416300 417782 417940 418594 423499 423708 426496 428568 434523 434817 438417 443242 444296 452876 454981 455360 456666 467569 469615 475943 488897 507284 509170 514837 515143 522112 529152 530011 531106 531115 531124 531250 531524 534019 534032 534386 534999 537239 537654 540915 541103 544835 553808 556876 556880 556888 566784 570740 580160 580174 584362 588177 600200 600218 610313 622792 625026 625189 628409 632594 637021 637023 638744 639810 642066 651168 663217 678127 684513 698801 702629 702971 705200 709523 711597 716596 717318 719767 720438 722677 724023 725624 727944 727959 735446 736850 738471 739178 740492 741808 741935 744896 755125 766649 770405 782302 783271 786791 788887 796147 796744 797006 806688 808155 808997 809001 823929 ] |
||||||||||||||||||||||||||||||
|
15.21 ms (11.17%) |
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 705200 702971 534386 651168 544835 438417 389482 396740 400465 405897 434817 823929 531250 541103 553808 556888 540915 584362 663217 720438 556880 566784 638744 808997 738471 740492 766649 788887 809001 397766 412332 416300 452876 426496 444296 454981 515143 529152 698801 711597 610313 622792 782901 727944 741808 744896 755125 625026 702629 684513 763214 531115 531524 507284 632594 600200 637023 628409 717318 639810 509170 537239 709523 719767 588177 782302 796147 796744 724023 797006 395306 402792 428568 434523 423499 423708 417782 467569 456666 534019 534032 514837 534999 556876 580160 580174 808155 806688 770405 727959 417940 455360 469615 475943 488897 522112 783271 600218 537654 531124 530011 531106 678127 637021 642066 716596 722677 570740 625189 786791 725624 741935 736850 739178 735446 191179 397508 408644 418594 443242 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.70%) |
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 191179 389482 395306 396740 397508 397766 400465 402792 405897 408644 412332 416300 417782 417940 418594 423499 423708 426496 428568 434523 434817 438417 443242 444296 452876 454981 455360 456666 467569 469615 475943 488897 507284 509170 514837 515143 522112 529152 530011 531106 531115 531124 531250 531524 534019 534032 534386 534999 537239 537654 540915 541103 544835 553808 556876 556880 556888 566784 570740 580160 580174 584362 588177 600200 600218 610313 622792 625026 625189 628409 632594 637021 637023 638744 639810 642066 651168 663217 678127 684513 698801 702629 702971 705200 709523 711597 716596 717318 719767 720438 722677 724023 725624 727944 727959 735446 736850 738471 739178 740492 741808 741935 744896 755125 766649 770405 782302 783271 786791 788887 796147 796744 797006 806688 808155 808997 809001 823929 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"extreme cum"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор cum"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хардкор cum"
]
|
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.