Query Metrics
7
Database Queries
7
Different statements
187.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.56 ms (85.78%) |
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 470407 473242 515014 519268 522877 525529 541292 541336 541388 541620 541631 541674 541725 541781 541822 541872 542190 542198 542480 542969 543480 544113 544500 547607 549767 549768 549779 550232 552123 558172 559060 559061 560076 560081 560085 563166 564519 564661 567382 567385 567405 567419 567425 567427 567432 567749 567951 568306 570394 571024 571056 571442 572535 572537 572541 572550 574235 574291 576625 576643 576651 576652 576676 576678 576693 576694 576698 576719 577355 577374 578952 579296 580252 583387 589640 590954 593173 605305 606056 612413 615726 615744 615757 619082 619379 621305 621318 621683 621976 622379 622981 623202 624358 624797 626546 628292 628312 629899 644005 644380 646432 648204 648256 648466 668943 672804 674118 690902 692237 692327 695201 699707 704533 705881 707306 711903 715670 725518 727769 ] |
||||||||||||||||||||||||||||||
|
16.89 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 621976 626546 644380 727769 699707 704533 705881 470407 519268 725518 541620 541725 542190 542480 542969 558172 560081 571056 572541 572550 574291 576643 576693 577355 580252 547607 560076 560085 564519 564661 567419 567432 568306 571024 571442 576698 541674 541781 543480 549768 567385 567405 570394 576625 576652 576676 576694 672804 690902 692237 707306 648204 648256 648466 692327 711903 715670 646432 668943 674118 695201 549779 550232 563166 567382 567427 567749 572537 576719 577374 579296 590954 619082 619379 622981 644005 621683 623202 624358 628292 593173 605305 606056 615726 628312 589640 615757 621305 621318 622379 612413 615744 624797 629899 473242 460903 515014 525529 541631 522877 541822 541872 542198 544500 549767 552123 559060 559061 567425 567951 572535 574235 576651 576678 578952 583387 541292 541336 541388 544113 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.59%) |
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 470407 473242 515014 519268 522877 525529 541292 541336 541388 541620 541631 541674 541725 541781 541822 541872 542190 542198 542480 542969 543480 544113 544500 547607 549767 549768 549779 550232 552123 558172 559060 559061 560076 560081 560085 563166 564519 564661 567382 567385 567405 567419 567425 567427 567432 567749 567951 568306 570394 571024 571056 571442 572535 572537 572541 572550 574235 574291 576625 576643 576651 576652 576676 576678 576693 576694 576698 576719 577355 577374 578952 579296 580252 583387 589640 590954 593173 605305 606056 612413 615726 615744 615757 619082 619379 621305 621318 621683 621976 622379 622981 623202 624358 624797 626546 628292 628312 629899 644005 644380 646432 648204 648256 648466 668943 672804 674118 690902 692237 692327 695201 699707 704533 705881 707306 711903 715670 725518 727769 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ретр boobs"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ретр boobs"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"retro boobs"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.