Query Metrics
7
Database Queries
7
Different statements
354.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.36 ms (58.49%) |
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 30958 185296 233102 379559 390209 391110 394548 400148 403039 405194 406210 407552 408024 415893 419145 419218 424502 446316 451983 453378 475082 475547 477896 478952 479176 480368 496549 498594 507168 507194 509278 511599 518740 519713 519946 520253 525239 526704 530777 531405 534318 535833 541618 547060 561356 565218 565938 573930 591778 599451 600577 604011 606396 606733 606831 607007 610266 613079 613200 618284 648587 650427 661657 663566 669220 673052 681024 688333 702455 710305 710881 717119 724502 726398 734707 737169 738432 741823 743565 744479 745044 746678 746773 746819 748450 749553 755408 757236 758719 768114 772188 779663 789761 795576 797706 797710 797788 800140 800738 802304 802979 811236 813638 814847 815145 815174 815279 815339 815403 815542 815640 815676 816295 816359 816564 816875 816967 817028 818780 824806 ] |
||||||||||||||||||||||||||||||
|
124.38 ms (35.08%) |
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 30958 185296 233102 379559 390209 391110 394548 400148 403039 405194 406210 407552 408024 415893 419145 419218 424502 446316 451983 453378 475082 475547 477896 478952 479176 480368 496549 498594 507168 507194 509278 511599 518740 519713 519946 520253 525239 526704 530777 531405 534318 535833 541618 547060 561356 565218 565938 573930 591778 599451 600577 604011 606396 606733 606831 607007 610266 613079 613200 618284 648587 650427 661657 663566 669220 673052 681024 688333 702455 710305 710881 717119 724502 726398 734707 737169 738432 741823 743565 744479 745044 746678 746773 746819 748450 749553 755408 757236 758719 768114 772188 779663 789761 795576 797706 797710 797788 800140 800738 802304 802979 811236 813638 814847 815145 815174 815279 815339 815403 815542 815640 815676 816295 816359 816564 816875 816967 817028 818780 824806 ] |
||||||||||||||||||||||||||||||
|
15.46 ms (4.36%) |
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 451983 561356 573930 663566 797788 606733 610266 768114 526704 525239 394548 405194 415893 534318 737169 746773 661657 816875 758719 407552 480368 710881 811236 507168 419218 453378 648587 772188 530777 403039 518740 507194 400148 802304 815145 816564 746678 591778 817028 618284 800738 738432 600577 565938 478952 419145 498594 824806 479176 477896 816295 520253 519946 604011 391110 813638 710305 797710 669220 741823 519713 815174 815676 816359 702455 565218 607007 185296 818780 30958 749553 390209 446316 688333 599451 606831 816967 802979 535833 755408 511599 815403 650427 681024 613200 475082 541618 233102 744479 724502 496549 408024 717119 379559 509278 746819 726398 815542 475547 673052 800140 745044 797706 795576 748450 815640 779663 789761 424502 743565 734707 757236 406210 815339 547060 606396 613079 531405 814847 815279 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"массаж члена женщиной"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж член женщин"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.48%) |
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.