Query Metrics
7
Database Queries
7
Different statements
188.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.08 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 386430 390173 392917 392928 394772 394780 394804 394816 394874 394931 395148 395153 398351 402103 402112 402142 402593 403039 403076 403361 403382 403467 403476 403487 403500 403543 403986 406071 406765 406820 410745 413982 414026 425935 428353 429405 443116 444383 444386 445576 445582 446945 448844 450254 452106 452258 458104 464862 464979 465175 473341 476202 476207 480513 480797 481584 486647 500771 505810 514928 515193 517750 520726 528773 529260 530774 531405 531407 532441 532682 536497 536697 536701 536740 537145 537939 538676 539420 539424 539456 540356 540359 540395 540433 540476 540478 540480 540483 540486 544789 553494 564740 564776 565152 568347 573803 576432 578418 578423 578426 580756 585736 594920 594960 596008 596054 597139 599143 600380 621645 622055 625417 629969 638282 645327 797656 806087 806099 806157 808570 ] |
||||||||||||||||||||||||||||||
|
17.43 ms (9.22%) |
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 599143 537145 514928 540356 578426 585736 565152 580756 596008 806099 806157 808570 515193 594920 600380 530774 629969 531405 465175 532682 538676 537939 531407 536697 517750 481584 622055 532441 540395 540480 645327 539420 553494 594960 578423 806087 540483 625417 597139 540433 568347 564776 621645 539424 564740 540478 428353 505810 576432 540486 386430 540476 394772 403076 403500 638282 392928 402593 394780 529260 539456 403543 596054 544789 406765 394816 394874 446945 573803 476202 402103 458104 392917 500771 445576 452106 414026 402142 403986 403361 403476 486647 536701 406071 390173 403467 536497 540359 394931 464979 520726 476207 395148 425935 395153 410745 445582 444383 429405 536740 403382 448844 450254 394804 398351 402112 403487 413982 443116 528773 797656 480797 452258 480513 473341 578418 403039 406820 444386 464862 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.60%) |
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 386430 390173 392917 392928 394772 394780 394804 394816 394874 394931 395148 395153 398351 402103 402112 402142 402593 403039 403076 403361 403382 403467 403476 403487 403500 403543 403986 406071 406765 406820 410745 413982 414026 425935 428353 429405 443116 444383 444386 445576 445582 446945 448844 450254 452106 452258 458104 464862 464979 465175 473341 476202 476207 480513 480797 481584 486647 500771 505810 514928 515193 517750 520726 528773 529260 530774 531405 531407 532441 532682 536497 536697 536701 536740 537145 537939 538676 539420 539424 539456 540356 540359 540395 540433 540476 540478 540480 540483 540486 544789 553494 564740 564776 565152 568347 573803 576432 578418 578423 578426 580756 585736 594920 594960 596008 596054 597139 599143 600380 621645 622055 625417 629969 638282 645327 797656 806087 806099 806157 808570 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bangbros big tits"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bangbros большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bangbros большие сиськ"
]
|
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.