Query Metrics
7
Database Queries
7
Different statements
151.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.55 ms (81.81%) |
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 341596 387218 409652 425503 432766 441095 445945 452010 452787 456393 458115 470092 474710 476706 477593 485541 487344 491461 494171 494484 494513 501440 502775 503659 504174 504481 506269 506801 507314 508891 512215 513949 514652 516744 517067 518237 523408 525393 528682 530020 531191 531195 532263 532849 533011 533373 533563 533848 534986 535456 535460 536588 539159 540511 540564 541216 541738 541925 545505 552938 562838 565273 567909 571146 574458 576632 576685 577357 580258 582767 590241 592492 599836 600173 613146 619466 621692 628707 633079 633097 634475 637048 637085 637680 637746 642742 647838 647860 649216 649498 660424 665781 670763 681031 682107 699554 718732 721103 726315 728035 743836 747012 747468 756398 775477 775976 784907 785059 796877 796881 804464 805838 809414 811690 814505 814526 814861 814903 815290 818439 ] |
||||||||||||||||||||||||||||||
|
17.24 ms (11.42%) |
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 387218 409652 425503 441095 432766 815290 814861 818439 452787 458115 539159 532263 545505 576685 582767 541216 576632 577357 665781 670763 681031 721103 552938 571146 574458 590241 592492 600173 621692 637680 637746 642742 637085 633097 634475 619466 628707 637048 784907 796881 743836 756398 785059 809414 811690 728035 747468 726315 747012 633079 718732 775477 775976 796877 805838 501440 504174 491461 502775 494484 456393 536588 599836 613146 804464 535456 518237 513949 533563 506801 540511 567909 341596 814903 476706 523408 532849 530020 504481 533373 503659 517067 525393 528682 541738 647838 474710 487344 516744 535460 485541 647860 506269 814526 814505 445945 470092 452010 477593 494171 507314 531191 534986 540564 494513 508891 531195 533848 512215 514652 533011 541925 565273 580258 682107 649216 649498 699554 660424 562838 ] |
||||||||||||||||||||||||||||||
|
3.61 ms (2.39%) |
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 341596 387218 409652 425503 432766 441095 445945 452010 452787 456393 458115 470092 474710 476706 477593 485541 487344 491461 494171 494484 494513 501440 502775 503659 504174 504481 506269 506801 507314 508891 512215 513949 514652 516744 517067 518237 523408 525393 528682 530020 531191 531195 532263 532849 533011 533373 533563 533848 534986 535456 535460 536588 539159 540511 540564 541216 541738 541925 545505 552938 562838 565273 567909 571146 574458 576632 576685 577357 580258 582767 590241 592492 599836 600173 613146 619466 621692 628707 633079 633097 634475 637048 637085 637680 637746 642742 647838 647860 649216 649498 660424 665781 670763 681031 682107 699554 718732 721103 726315 728035 743836 747012 747468 756398 775477 775976 784907 785059 796877 796881 804464 805838 809414 811690 814505 814526 814861 814903 815290 818439 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double pussy mature"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double pussy mature"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double pussy mature"
]
|
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.