Query Metrics
7
Database Queries
7
Different statements
193.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.69 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 350574 382138 411228 419836 419843 426440 429300 429508 444649 444828 446091 446992 457518 464253 469640 471141 476503 476610 478442 481812 485308 494274 494734 497904 501656 502488 503786 506810 510557 512871 513979 516988 517729 518628 518887 519777 526000 526475 529050 529883 530358 532904 533274 535562 536461 536691 537927 538804 540136 541576 543856 546798 546800 546808 549223 550176 550679 552006 552070 552602 559192 559208 559246 559856 560904 562467 566791 569720 569743 576657 598325 602037 605487 609901 610959 615658 616000 623838 623868 628517 632557 650810 668012 668545 680137 704180 714666 715826 716629 716756 726291 726292 728768 735727 751503 755377 758533 772964 782544 789805 794809 796740 796773 800628 801593 802105 806674 810841 814685 816994 817025 817036 817174 817186 817187 818318 819564 819608 819613 824921 ] |
||||||||||||||||||||||||||||||
|
15.96 ms (8.26%) |
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 518628 559856 628517 814685 446992 543856 569720 569743 715826 704180 726291 550679 429508 494274 559246 559192 716629 801593 546808 529050 540136 758533 598325 559208 615658 819564 526000 818318 714666 609901 772964 796740 519777 576657 802105 610959 782544 810841 806674 494734 552070 789805 457518 538804 716756 819608 476610 616000 817187 816994 533274 632557 536691 751503 728768 819613 623838 726292 485308 526475 552006 550176 549223 546800 536461 471141 497904 444828 562467 755377 419836 796773 476503 512871 518887 817174 817025 546798 478442 552602 623868 602037 429300 419843 382138 529883 535562 506810 735727 411228 817036 501656 469640 800628 444649 532904 794809 817186 530358 566791 350574 446091 503786 516988 513979 668012 560904 426440 510557 502488 537927 541576 668545 650810 605487 481812 464253 517729 680137 824921 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.44%) |
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 350574 382138 411228 419836 419843 426440 429300 429508 444649 444828 446091 446992 457518 464253 469640 471141 476503 476610 478442 481812 485308 494274 494734 497904 501656 502488 503786 506810 510557 512871 513979 516988 517729 518628 518887 519777 526000 526475 529050 529883 530358 532904 533274 535562 536461 536691 537927 538804 540136 541576 543856 546798 546800 546808 549223 550176 550679 552006 552070 552602 559192 559208 559246 559856 560904 562467 566791 569720 569743 576657 598325 602037 605487 609901 610959 615658 616000 623838 623868 628517 632557 650810 668012 668545 680137 704180 714666 715826 716629 716756 726291 726292 728768 735727 751503 755377 758533 772964 782544 789805 794809 796740 796773 800628 801593 802105 806674 810841 814685 816994 817025 817036 817174 817186 817187 818318 819564 819608 819613 824921 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"slave girl bondage"
]
|
||||||||||||||||||||||||||||||
|
2.28 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован девушк бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.96%) |
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.