Query Metrics
7
Database Queries
7
Different statements
171.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.20 ms (85.99%) |
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 388552 397406 431592 431718 449014 450721 456699 457518 458401 471951 473529 479722 496429 497924 508909 511090 515423 516438 518887 522675 525235 526941 528076 531583 531849 532396 532904 533138 540200 542059 542397 543843 543865 545205 546813 549272 550574 565944 566791 569726 569733 569769 569770 589431 590241 590402 598126 598612 600472 606821 607985 608541 609901 623085 626489 632095 632868 640432 670248 676205 680137 680172 698100 706467 706933 707341 714666 716652 716724 719651 726082 726736 731827 739584 741239 750115 750547 750788 750789 751702 756258 761584 763520 764154 765234 766835 772032 772964 777320 783749 784101 784770 785166 785723 787600 790042 791107 793383 795684 797098 797115 799362 800236 800573 800628 804184 804193 805335 806674 806833 808490 809811 809816 810065 817001 817013 817108 817206 819184 820365 ] |
||||||||||||||||||||||||||||||
|
14.06 ms (8.21%) |
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 546813 716652 806833 598126 589431 707341 518887 532396 716724 676205 609901 793383 739584 623085 632095 431592 800628 809816 763520 772964 726082 590241 598612 458401 569726 670248 804184 806674 810065 741239 777320 516438 545205 569769 525235 590402 785723 457518 784770 731827 797098 531849 565944 761584 533138 706467 783749 751702 820365 750547 532904 785166 800236 496429 449014 714666 607985 719651 800573 388552 543865 528076 397406 540200 456699 804193 805335 808490 765234 790042 791107 817001 819184 698100 787600 750789 431718 608541 497924 569770 680137 542059 450721 542397 531583 784101 756258 479722 515423 550574 772032 508909 626489 799362 511090 566791 640432 764154 522675 680172 706933 600472 606821 809811 766835 750115 750788 526941 795684 471951 473529 543843 817013 817108 817206 549272 569733 632868 726736 797115 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.66%) |
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 388552 397406 431592 431718 449014 450721 456699 457518 458401 471951 473529 479722 496429 497924 508909 511090 515423 516438 518887 522675 525235 526941 528076 531583 531849 532396 532904 533138 540200 542059 542397 543843 543865 545205 546813 549272 550574 565944 566791 569726 569733 569769 569770 589431 590241 590402 598126 598612 600472 606821 607985 608541 609901 623085 626489 632095 632868 640432 670248 676205 680137 680172 698100 706467 706933 707341 714666 716652 716724 719651 726082 726736 731827 739584 741239 750115 750547 750788 750789 751702 756258 761584 763520 764154 765234 766835 772032 772964 777320 783749 784101 784770 785166 785723 787600 790042 791107 793383 795684 797098 797115 799362 800236 800573 800628 804184 804193 805335 806674 806833 808490 809811 809816 810065 817001 817013 817108 817206 819184 820365 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bdsm fuck"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бдсм секс"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.93%) |
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.