Query Metrics
7
Database Queries
7
Different statements
171.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.28 ms (84.59%) |
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 6669 398200 398513 398534 398774 399905 400950 416889 427226 432683 434370 435366 435656 441467 441503 441510 441577 442090 446950 456804 457935 458385 459477 459647 461275 467113 473331 484174 488242 496124 518944 521019 527100 527211 529379 533836 534471 534532 546223 552810 558187 559789 561240 564557 570760 572295 597670 597673 599115 602283 604215 608092 619974 620653 622167 623037 623947 627225 642244 667376 674522 674948 682882 685401 693359 697170 698228 698732 700031 702488 703577 706785 712517 712525 714613 715370 717187 718822 720187 722021 722925 724978 730336 734332 737561 739552 744975 749016 756074 757867 761015 766102 766788 769528 776133 779278 779599 780268 782539 782935 784808 785462 788325 788486 790483 792142 792376 792403 796126 797389 799419 800730 800731 803726 805281 809462 811138 811764 813089 822309 ] |
||||||||||||||||||||||||||||||
|
15.44 ms (8.99%) |
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 766788 608092 627225 702488 779599 780268 784808 785462 809462 458385 461275 473331 398513 446950 674948 685401 441467 769528 398774 399905 484174 527100 529379 533836 534471 496124 570760 697170 682882 698732 693359 561240 619974 622167 642244 597670 620653 700031 712517 722925 400950 427226 432683 441510 442090 822309 467113 534532 667376 717187 718822 558187 559789 776133 782935 788486 805281 811138 792142 792376 799419 800730 724978 766102 782539 790483 800731 803726 811764 730336 756074 757867 761015 720187 722021 796126 797389 459647 435366 416889 459477 398200 441577 457935 488242 518944 527211 712525 674522 703577 546223 599115 623947 788325 734332 441503 572295 744975 6669 398534 435656 434370 456804 521019 552810 714613 715370 698228 706785 564557 597673 602283 623037 604215 813089 779278 792403 737561 739552 749016 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.65%) |
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 6669 398200 398513 398534 398774 399905 400950 416889 427226 432683 434370 435366 435656 441467 441503 441510 441577 442090 446950 456804 457935 458385 459477 459647 461275 467113 473331 484174 488242 496124 518944 521019 527100 527211 529379 533836 534471 534532 546223 552810 558187 559789 561240 564557 570760 572295 597670 597673 599115 602283 604215 608092 619974 620653 622167 623037 623947 627225 642244 667376 674522 674948 682882 685401 693359 697170 698228 698732 700031 702488 703577 706785 712517 712525 714613 715370 717187 718822 720187 722021 722925 724978 730336 734332 737561 739552 744975 749016 756074 757867 761015 766102 766788 769528 776133 779278 779599 780268 782539 782935 784808 785462 788325 788486 790483 792142 792376 792403 796126 797389 799419 800730 800731 803726 805281 809462 811138 811764 813089 822309 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deep amateur"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"deep любительск"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"deep любительск"
]
|
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.