Query Metrics
7
Database Queries
7
Different statements
156.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.55 ms (84.77%) |
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 58701 72822 79355 96665 96946 97763 109313 130045 130089 181397 188337 188621 193342 320078 383000 383501 405074 408613 410272 422672 430526 437470 452263 452813 455886 460171 462751 468340 470493 479071 479074 493088 501377 505625 507284 511254 512509 512561 516375 517847 522157 523868 530372 530373 531259 531824 531836 532839 532966 533064 533773 536305 536359 536538 541849 548454 556029 566503 571213 577435 580107 583460 583500 591174 595761 599847 599861 599964 600249 600289 601584 605337 615915 619407 631162 631902 632184 632641 636308 639759 645236 646849 676088 678053 681661 692806 699757 703533 706232 712891 714122 720795 734469 739606 745326 752611 761530 770840 770909 772796 775024 775054 779560 788169 789961 792184 796285 801536 802488 805598 809471 815955 817059 817113 817176 817334 817377 820171 828872 ] |
||||||||||||||||||||||||||||||
|
14.12 ms (9.03%) |
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 817377 605337 452263 631902 536305 410272 96665 739606 548454 507284 779560 523868 802488 599964 820171 817113 817176 531824 706232 796285 734469 752611 828872 516375 556029 541849 531294 801536 761530 512509 517847 566503 599861 601584 512561 522157 639759 712891 583500 599847 678053 580107 631162 437470 452813 532839 533773 646849 676088 600249 600289 532966 591174 181397 188337 815955 632641 770840 789961 501377 536538 772796 720795 615915 703533 632184 775024 805598 792184 188621 422672 430526 530372 817059 320078 788169 72822 681661 809471 455886 79355 619407 470493 479074 468340 531836 583460 479071 130045 817334 745326 505625 383000 462751 408613 58701 511254 531259 460171 405074 533064 577435 636308 383501 536359 530373 645236 571213 714122 595761 193342 96946 699757 770909 97763 692806 109313 130089 493088 775054 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.80%) |
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 58701 72822 79355 96665 96946 97763 109313 130045 130089 181397 188337 188621 193342 320078 383000 383501 405074 408613 410272 422672 430526 437470 452263 452813 455886 460171 462751 468340 470493 479071 479074 493088 501377 505625 507284 511254 512509 512561 516375 517847 522157 523868 530372 530373 531259 531824 531836 532839 532966 533064 533773 536305 536359 536538 541849 548454 556029 566503 571213 577435 580107 583460 583500 591174 595761 599847 599861 599964 600249 600289 601584 605337 615915 619407 631162 631902 632184 632641 636308 639759 645236 646849 676088 678053 681661 692806 699757 703533 706232 712891 714122 720795 734469 739606 745326 752611 761530 770840 770909 772796 775024 775054 779560 788169 789961 792184 796285 801536 802488 805598 809471 815955 817059 817113 817176 817334 817377 820171 828872 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин double секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин double секс"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother double fuck"
]
|
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.