Query Metrics
7
Database Queries
7
Different statements
592.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
359.14 ms (60.60%) |
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 14365 161358 325432 328446 373981 382217 382362 386728 391144 393087 396593 396781 398388 404384 410353 411052 414101 416090 419426 419600 425942 429171 429823 433512 433555 443237 446343 457296 457757 463845 467049 483497 488931 490267 495412 499717 506304 512683 515777 529318 530317 532752 533490 535395 536570 536632 536740 545713 552958 581370 584576 597115 601198 602061 604480 604500 605174 606392 606657 606956 607101 613015 622582 633112 636489 638533 641075 645618 650236 651872 652548 662047 663321 669171 673731 675008 680161 684970 697130 707290 718947 719807 720924 721060 722549 724262 724283 724536 728225 728442 728738 729181 731276 731481 731888 737673 753962 754170 757458 770904 773998 774243 774524 777008 790963 794769 800475 801082 804597 805302 805307 805607 806103 808238 811477 812372 817074 822286 826232 826521 ] |
||||||||||||||||||||||||||||||
|
206.03 ms (34.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black big cock"
]
|
||||||||||||||||||||||||||||||
|
19.68 ms (3.32%) |
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 728442 398388 536740 552958 651872 652548 662047 684970 584576 601198 805607 794769 728225 728738 731276 604480 396781 675008 161358 817074 826232 826521 512683 697130 804597 724536 770904 724262 754170 757458 722549 410353 433512 446343 545713 581370 650236 707290 613015 638533 812372 811477 731888 729181 14365 515777 393087 822286 463845 488931 490267 530317 535395 669171 673731 605174 606956 622582 641075 790963 774524 801082 774243 724283 777008 806103 753962 411052 419426 808238 721060 805302 325432 328446 396593 404384 433555 414101 425942 429171 429823 457296 467049 495412 533490 536570 529318 536632 532752 645618 663321 720924 680161 718947 719807 597115 606392 636489 602061 607101 800475 773998 805307 731481 737673 604500 606657 633112 416090 386728 391144 457757 382217 419600 483497 506304 499717 373981 382362 443237 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (0.48%) |
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 14365 161358 325432 328446 373981 382217 382362 386728 391144 393087 396593 396781 398388 404384 410353 411052 414101 416090 419426 419600 425942 429171 429823 433512 433555 443237 446343 457296 457757 463845 467049 483497 488931 490267 495412 499717 506304 512683 515777 529318 530317 532752 533490 535395 536570 536632 536740 545713 552958 581370 584576 597115 601198 602061 604480 604500 605174 606392 606657 606956 607101 613015 622582 633112 636489 638533 641075 645618 650236 651872 652548 662047 663321 669171 673731 675008 680161 684970 697130 707290 718947 719807 720924 721060 722549 724262 724283 724536 728225 728442 728738 729181 731276 731481 731888 737673 753962 754170 757458 770904 773998 774243 774524 777008 790963 794769 800475 801082 804597 805302 805307 805607 806103 808238 811477 812372 817074 822286 826232 826521 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black большие cock"
]
|
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.