Query Metrics
7
Database Queries
7
Different statements
161.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.72 ms (84.24%) |
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 249926 263759 282858 383095 385205 389771 390538 390747 395452 395489 396565 396608 400928 401367 401840 402618 404415 406306 407683 411145 414933 415640 421093 421366 423933 430573 441952 443116 452879 455080 464494 466624 471866 475052 475286 477052 477482 482961 489361 497514 499894 510561 511923 512363 514261 515143 516746 519364 519379 522639 525091 526938 529714 531115 538513 544829 559783 568258 602241 606101 622297 627233 628485 632663 633147 633744 634742 639810 640802 641126 641951 645230 647993 652766 666856 667276 668714 669025 669370 682478 694178 699730 705277 707148 721106 723885 723930 724250 735202 742291 742472 743120 744427 746230 748257 752614 770764 771852 775780 776942 782361 786985 788569 789223 792741 795055 797001 798910 800223 801615 801628 801931 803824 805543 806271 811994 818387 818460 827171 827957 ] |
||||||||||||||||||||||||||||||
|
14.80 ms (9.19%) |
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 746230 786985 421093 743120 668714 795055 742472 827171 647993 606101 775780 632663 263759 401367 441952 415640 443116 423933 827957 471866 477052 452879 475052 477482 514261 519379 538513 516746 522639 525091 464494 544829 559783 568258 652766 666856 669025 602241 634742 641951 622297 627233 628485 803824 752614 789223 744427 723885 742291 699730 792741 797001 801615 421366 466624 512363 526938 497514 510561 511923 402618 411145 430573 529714 669370 801628 735202 395452 396565 707148 724250 800223 705277 639810 395489 682478 811994 455080 489361 519364 383095 249926 400928 404415 818460 805543 385205 389771 499894 282858 406306 515143 640802 531115 633744 776942 770764 798910 771852 782361 641126 396608 414933 818387 475286 482961 667276 694178 645230 721106 788569 801931 806271 723930 748257 633147 401840 390747 407683 390538 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (2.42%) |
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 249926 263759 282858 383095 385205 389771 390538 390747 395452 395489 396565 396608 400928 401367 401840 402618 404415 406306 407683 411145 414933 415640 421093 421366 423933 430573 441952 443116 452879 455080 464494 466624 471866 475052 475286 477052 477482 482961 489361 497514 499894 510561 511923 512363 514261 515143 516746 519364 519379 522639 525091 526938 529714 531115 538513 544829 559783 568258 602241 606101 622297 627233 628485 632663 633147 633744 634742 639810 640802 641126 641951 645230 647993 652766 666856 667276 668714 669025 669370 682478 694178 699730 705277 707148 721106 723885 723930 724250 735202 742291 742472 743120 744427 746230 748257 752614 770764 771852 775780 776942 782361 786985 788569 789223 792741 795055 797001 798910 800223 801615 801628 801931 803824 805543 806271 811994 818387 818460 827171 827957 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy hardcore sex"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy хардкор секс"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy хардкор секс"
]
|
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.