Query Metrics
7
Database Queries
7
Different statements
184.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.17 ms (84.73%) |
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 388712 395711 397361 400857 409097 419113 420398 425028 425588 425945 425967 429985 431133 432236 432869 434624 438851 443600 443652 445742 445879 453511 463059 463094 464129 470344 472693 474167 478453 483081 484161 484977 485773 487920 489674 494036 494260 494717 494731 494752 494980 495740 499878 502092 502436 502743 507528 512203 515137 516775 517750 521772 534293 534664 535269 536726 538973 540952 543107 546106 550325 550689 551111 552043 554539 557161 558522 559692 560169 562337 562882 565542 566028 567149 568835 572811 575176 576343 581665 582617 584382 587757 591109 591190 592320 595011 595944 603643 610290 614430 615015 619423 641901 653377 663370 665121 669695 669738 676117 677974 684910 719343 724425 725607 732061 739557 748255 749981 750445 770824 784315 804771 807407 807687 808467 811090 811845 814808 814923 823198 ] |
||||||||||||||||||||||||||||||
|
17.86 ms (9.69%) |
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 535269 494752 550689 562337 566028 572811 591109 610290 804771 725607 495740 502092 395711 397361 425967 484161 485773 494717 512203 487920 575176 663370 676117 560169 595944 770824 739557 641901 453511 478453 463094 507528 515137 814923 445742 502743 536726 546106 551111 592320 614430 807407 807687 724425 732061 749981 474167 431133 483081 814808 823198 516775 557161 567149 584382 576343 603643 750445 811090 748255 420398 521772 502436 534293 665121 808467 409097 568835 552043 615015 425588 388712 565542 494036 499878 438851 494980 538973 811845 429985 443600 472693 562882 653377 669695 595011 784315 425028 443652 543107 554539 669738 582617 419113 432236 470344 494731 425945 445879 494260 534664 581665 591190 587757 619423 400857 432869 463059 489674 484977 434624 464129 517750 558522 559692 540952 550325 677974 684910 719343 ] |
||||||||||||||||||||||||||||||
|
4.01 ms (2.18%) |
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 388712 395711 397361 400857 409097 419113 420398 425028 425588 425945 425967 429985 431133 432236 432869 434624 438851 443600 443652 445742 445879 453511 463059 463094 464129 470344 472693 474167 478453 483081 484161 484977 485773 487920 489674 494036 494260 494717 494731 494752 494980 495740 499878 502092 502436 502743 507528 512203 515137 516775 517750 521772 534293 534664 535269 536726 538973 540952 543107 546106 550325 550689 551111 552043 554539 557161 558522 559692 560169 562337 562882 565542 566028 567149 568835 572811 575176 576343 581665 582617 584382 587757 591109 591190 592320 595011 595944 603643 610290 614430 615015 619423 641901 653377 663370 665121 669695 669738 676117 677974 684910 719343 724425 725607 732061 739557 748255 749981 750445 770824 784315 804771 807407 807687 808467 811090 811845 814808 814923 823198 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс в очках"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс очкастые"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.68%) |
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.