Query Metrics
7
Database Queries
7
Different statements
254.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
222.45 ms (87.51%) |
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 413134 413703 422392 422429 425588 425979 426367 429328 433584 439467 447147 447529 447812 449158 450158 451580 453261 453638 454239 455510 456686 462266 463966 464598 471328 474964 475907 477881 478471 479856 481297 483167 483226 486530 491659 491684 491712 496795 502729 504220 511711 513298 514384 520093 520099 521973 522244 525496 526865 528963 529057 529075 546776 549787 551212 557213 561509 564660 565771 566041 566052 575494 576343 577433 582297 582481 586650 598466 598840 599162 599246 599872 601170 607342 613823 619822 620201 620938 620980 623085 623485 625532 627007 630309 646022 647119 651604 653545 664157 671888 684029 687140 695298 702007 707604 711358 717410 719457 721187 727665 733651 735654 736252 737156 759608 761634 767018 771821 771837 778069 780737 782307 789597 790944 798834 804902 805049 809965 809976 810924 ] |
||||||||||||||||||||||||||||||
|
21.54 ms (8.47%) |
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 664157 695298 721187 653545 684029 702007 717410 646022 651604 671888 546776 549787 551212 557213 561509 565771 566041 582297 598840 623085 599162 607342 613823 619822 627007 599246 599872 586650 598466 623485 630309 778069 767018 805049 727665 737156 771837 771821 620201 625532 780737 429328 453261 475907 481297 449158 450158 456686 479856 422392 426367 447529 447812 453638 462266 464598 471328 413703 422429 454239 474964 447147 451580 463966 504220 511711 520093 483167 491712 521973 526865 496795 514384 520099 522244 483226 502729 687140 719457 798834 810924 759608 790944 809965 413134 425979 439467 566052 582481 601170 433584 455510 477881 478471 528963 513298 529075 491659 525496 425588 491684 486530 529057 711358 647119 707604 564660 620938 620980 809976 782307 761634 804902 735654 736252 733651 789597 575494 576343 577433 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.21%) |
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 413134 413703 422392 422429 425588 425979 426367 429328 433584 439467 447147 447529 447812 449158 450158 451580 453261 453638 454239 455510 456686 462266 463966 464598 471328 474964 475907 477881 478471 479856 481297 483167 483226 486530 491659 491684 491712 496795 502729 504220 511711 513298 514384 520093 520099 521973 522244 525496 526865 528963 529057 529075 546776 549787 551212 557213 561509 564660 565771 566041 566052 575494 576343 577433 582297 582481 586650 598466 598840 599162 599246 599872 601170 607342 613823 619822 620201 620938 620980 623085 623485 625532 627007 630309 646022 647119 651604 653545 664157 671888 684029 687140 695298 702007 707604 711358 717410 719457 721187 727665 733651 735654 736252 737156 759608 761634 767018 771821 771837 778069 780737 782307 789597 790944 798834 804902 805049 809965 809976 810924 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural porn"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные porn"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные porn"
]
|
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.