Query Metrics
7
Database Queries
7
Different statements
573.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.36 ms (37.00%) |
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 31329 96029 188240 384144 400844 409312 411349 411448 414374 415866 421108 424259 428113 428179 429699 429869 432639 439546 439572 440955 452589 452772 452881 453157 463260 463792 467932 468307 470971 472869 476225 479105 481748 482549 483567 486393 491969 493159 494444 499346 503679 506836 512915 513431 513963 514245 532467 534709 538925 564282 582339 590150 593582 593865 619109 620663 621323 632094 655298 656904 665975 675416 699546 705466 705630 712094 718996 724021 726925 743510 744970 748690 756103 756425 757726 758079 759900 759958 759980 760792 760831 761127 761719 765458 770881 770920 770926 772549 773475 775473 777737 778091 779064 782562 785972 791589 793138 797151 801475 802065 802114 802202 802547 805597 805600 810291 811490 815050 815179 815227 817238 817349 817729 818290 818450 818532 819128 821187 822585 823607 ] |
||||||||||||||||||||||||||||||
|
207.22 ms (36.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал мам женщин чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
127.59 ms (22.23%) |
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 31329 96029 188240 384144 400844 409312 411349 411448 414374 415866 421108 424259 428113 428179 429699 429869 432639 439546 439572 440955 452589 452772 452881 453157 463260 463792 467932 468307 470971 472869 476225 479105 481748 482549 483567 486393 491969 493159 494444 499346 503679 506836 512915 513431 513963 514245 532467 534709 538925 564282 582339 590150 593582 593865 619109 620663 621323 632094 655298 656904 665975 675416 699546 705466 705630 712094 718996 724021 726925 743510 744970 748690 756103 756425 757726 758079 759900 759958 759980 760792 760831 761127 761719 765458 770881 770920 770926 772549 773475 775473 777737 778091 779064 782562 785972 791589 793138 797151 801475 802065 802114 802202 802547 805597 805600 810291 811490 815050 815179 815227 817238 817349 817729 818290 818450 818532 819128 821187 822585 823607 ] |
||||||||||||||||||||||||||||||
|
21.30 ms (3.71%) |
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 415866 491969 421108 494444 772549 452881 411448 675416 409312 513431 188240 440955 479105 439572 481748 483567 96029 414374 534709 791589 452772 463260 822585 821187 486393 503679 665975 31329 429699 429869 467932 593865 463792 472869 619109 439546 513963 453157 817729 514245 778091 802065 744970 743510 757726 476225 452589 712094 428179 656904 785972 810291 775473 758079 773475 756103 761127 802114 564282 777737 724021 726925 761719 765458 632094 793138 506836 818290 815179 538925 655298 705466 802202 797151 705630 432639 493159 620663 400844 470971 512915 815050 815227 817238 817349 819128 818450 818532 823607 499346 532467 582339 699546 593582 779064 805597 782562 801475 748690 759958 770920 802547 811490 760792 756425 760831 770926 759900 770881 621323 805600 428113 411349 468307 384144 482549 590150 424259 759980 718996 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал мам женщин чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал тетки чулки"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.26%) |
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.