Query Metrics
7
Database Queries
7
Different statements
185.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.22 ms (84.71%) |
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 425816 428488 435768 442991 453456 459972 460796 462136 462516 468824 470267 471408 474824 482251 489101 489791 491984 494705 496320 506225 509381 513334 518056 518257 518968 520811 525776 528898 529722 534220 534258 536434 549511 551581 552534 554615 555095 559097 559099 559555 560733 562047 562732 564245 564488 565055 565463 569466 570405 579189 579330 579751 579775 580198 581626 581708 583414 585477 591830 598412 598989 599688 599722 601300 603809 605261 605481 609815 617766 619878 620285 633528 639157 647621 651214 669213 678387 682071 686224 689002 689967 693576 699347 702740 703505 705624 707332 708810 709298 711311 712021 714074 714188 715323 717493 718958 721908 723945 723955 724045 724456 725165 727076 728296 733048 735554 743406 744563 747655 750579 753148 756279 757114 757307 758564 781185 781689 817482 ] |
||||||||||||||||||||||||||||||
|
17.80 ms (9.59%) |
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 747655 756279 758564 725165 727076 750579 603809 697943 709298 781185 528898 536434 489791 491984 509381 585477 633528 482251 506225 462136 460796 453456 459972 489101 518968 518056 580198 564488 554615 559099 711311 617766 442991 435768 496320 529722 534258 534220 518257 565463 570405 579751 581708 669213 678387 559555 564245 581626 609815 743406 757307 728296 708810 462516 471408 474824 425816 470267 428488 468824 494705 513334 520811 817482 525776 560733 579330 583414 549511 551581 562732 552534 555095 565055 569466 579775 686224 707332 712021 715323 717493 721908 682071 689002 693576 714074 718958 647621 651214 689967 699347 702740 705624 714188 559097 562047 579189 591830 598412 599688 619878 598989 605261 620285 599722 601300 639157 605481 781689 723955 724045 733048 724456 744563 723945 753148 735554 757114 618229 703505 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (1.86%) |
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 425816 428488 435768 442991 453456 459972 460796 462136 462516 468824 470267 471408 474824 482251 489101 489791 491984 494705 496320 506225 509381 513334 518056 518257 518968 520811 525776 528898 529722 534220 534258 536434 549511 551581 552534 554615 555095 559097 559099 559555 560733 562047 562732 564245 564488 565055 565463 569466 570405 579189 579330 579751 579775 580198 581626 581708 583414 585477 591830 598412 598989 599688 599722 601300 603809 605261 605481 609815 617766 619878 620285 633528 639157 647621 651214 669213 678387 682071 686224 689002 689967 693576 699347 702740 703505 705624 707332 708810 709298 711311 712021 714074 714188 715323 717493 718958 721908 723945 723955 724045 724456 725165 727076 728296 733048 735554 743406 744563 747655 750579 753148 756279 757114 757307 758564 781185 781689 817482 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"caught big cock"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"caught большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"caught большие cock"
]
|
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.