Query Metrics
7
Database Queries
7
Different statements
350.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.40 ms (60.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
119.14 ms (33.94%) |
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 544912 544924 550800 553516 558516 558631 558673 559510 564620 569277 575221 575228 575258 576130 576133 577989 580988 583570 584218 585869 585920 586035 586127 587151 587787 587831 589235 589614 589941 590295 590489 592609 592740 593183 595491 595548 596039 596074 596179 596222 598153 598943 599091 599223 599406 599601 599647 600183 600223 600810 600942 601860 602320 602387 603125 604970 605177 605240 605262 607365 607379 607382 611066 613142 614592 618228 618932 621588 622077 625462 626454 628592 628722 631260 631354 633012 642085 642314 646020 649388 649495 651457 652975 659472 659476 660296 661440 661514 661534 662004 664776 670405 670762 671417 673566 675446 678621 679280 679283 683286 683296 685692 687424 693424 697663 700268 704243 705221 705654 708351 708521 709682 709824 709846 711731 711734 717716 722305 723291 723298 ] |
||||||||||||||||||||||||||||||
|
12.02 ms (3.42%) |
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 708521 717716 646020 651457 659476 660296 661440 661514 661534 670405 670762 673566 675446 678621 683296 687424 697663 700268 704243 705221 705654 708351 709824 709846 722305 723291 649388 649495 652975 659472 662004 664776 671417 679280 679283 683286 685692 693424 709682 711731 711734 723298 544912 544924 550800 553516 558516 558631 558673 559510 564620 569277 575221 575228 575258 576130 576133 577989 580988 583570 584218 585920 586035 586127 587151 589941 590489 599406 602320 607365 614592 618932 625462 626454 631354 642085 590295 592609 592740 599223 599601 602387 605177 605262 607379 611066 613142 618228 621588 622077 633012 585869 587787 587831 593183 595491 595548 596074 596179 596222 598153 598943 599091 600223 601860 604970 607382 628592 628722 631260 642314 589235 589614 596039 599647 600183 600810 600942 603125 605240 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (0.87%) |
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 544912 544924 550800 553516 558516 558631 558673 559510 564620 569277 575221 575228 575258 576130 576133 577989 580988 583570 584218 585869 585920 586035 586127 587151 587787 587831 589235 589614 589941 590295 590489 592609 592740 593183 595491 595548 596039 596074 596179 596222 598153 598943 599091 599223 599406 599601 599647 600183 600223 600810 600942 601860 602320 602387 603125 604970 605177 605240 605262 607365 607379 607382 611066 613142 614592 618228 618932 621588 622077 625462 626454 628592 628722 631260 631354 633012 642085 642314 646020 649388 649495 651457 652975 659472 659476 660296 661440 661514 661534 662004 664776 670405 670762 671417 673566 675446 678621 679280 679283 683286 683296 685692 687424 693424 697663 700268 704243 705221 705654 708351 708521 709682 709824 709846 711731 711734 717716 722305 723291 723298 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo skinny"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло худые"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.