Query Metrics
7
Database Queries
7
Different statements
201.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.80 ms (85.26%) |
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 460903 473242 519268 522915 525462 538915 541292 541329 541336 541602 541620 541674 541725 541728 541781 542190 542969 543477 546621 547607 549768 549771 549779 550232 551916 554321 559061 560080 560085 562826 562828 563166 563184 563225 563447 563449 564661 566696 567382 567385 567404 567419 567424 567427 567959 570394 572541 573914 574291 576634 576643 576652 576676 576684 576696 576698 576700 576711 576719 577360 580258 580286 581300 583387 584004 589640 591294 592451 592456 592477 603147 605305 605345 606208 615726 615740 615748 615751 619076 619082 619379 619401 619466 619468 620164 621312 621318 621976 622379 622976 622978 623202 624154 626546 628292 628312 628314 644259 644280 644380 648256 648466 649604 652541 670107 671735 674117 692237 693872 694058 695201 699707 699730 702061 703833 704533 707306 711903 727769 801471 ] |
||||||||||||||||||||||||||||||
|
18.25 ms (9.06%) |
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 592477 606208 620164 644259 615751 619466 621976 626546 644380 727769 699707 704533 519268 693872 541725 542190 563447 572541 543477 560085 567419 576698 541674 570394 580258 584004 692237 567427 644280 563449 648256 619401 628312 622379 615740 615748 562828 541602 576700 525462 576711 703833 554321 567404 592451 699730 652541 580286 622976 622978 628314 702061 801471 577360 560080 538915 541620 542969 574291 576643 547607 564661 566696 541781 546621 549768 563184 563225 567385 567959 576652 576676 707306 648466 649604 671735 694058 711903 670107 695201 549779 550232 563166 567382 576719 619082 619379 623202 628292 605305 615726 619468 589640 621318 624154 619076 621312 473242 460903 522915 576696 541329 551916 559061 567424 583387 674117 549771 573914 576634 576684 592456 603147 541728 541292 541336 562826 581300 605345 591294 ] |
||||||||||||||||||||||||||||||
|
3.89 ms (1.93%) |
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 460903 473242 519268 522915 525462 538915 541292 541329 541336 541602 541620 541674 541725 541728 541781 542190 542969 543477 546621 547607 549768 549771 549779 550232 551916 554321 559061 560080 560085 562826 562828 563166 563184 563225 563447 563449 564661 566696 567382 567385 567404 567419 567424 567427 567959 570394 572541 573914 574291 576634 576643 576652 576676 576684 576696 576698 576700 576711 576719 577360 580258 580286 581300 583387 584004 589640 591294 592451 592456 592477 603147 605305 605345 606208 615726 615740 615748 615751 619076 619082 619379 619401 619466 619468 620164 621312 621318 621976 622379 622976 622978 623202 624154 626546 628292 628312 628314 644259 644280 644380 648256 648466 649604 652541 670107 671735 674117 692237 693872 694058 695201 699707 699730 702061 703833 704533 707306 711903 727769 801471 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro big ass"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр большая большие жоп"
]
|
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.