Query Metrics
7
Database Queries
7
Different statements
231.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.48 ms (89.21%) |
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 45856 107606 144252 385750 386565 389631 392605 395343 395646 402848 403353 403986 414220 420674 424975 427737 428881 429939 430508 436608 442557 443245 444453 444695 445272 446656 447244 451573 457254 460051 460852 461013 463669 465996 466002 466142 466656 466676 469164 470737 471481 472106 475347 476510 476974 478370 480788 485461 489376 489439 489488 492841 494400 494413 494614 495023 495557 498548 499006 499177 500436 508563 512555 512597 513015 513767 517222 517941 520690 521116 528817 529424 530996 532008 533418 551293 553964 558617 560183 564744 565960 566579 569440 570284 572765 573817 579261 580246 584436 585108 587039 588092 598388 603980 653534 698385 719062 723764 728283 738259 739959 741212 743232 744340 753333 753752 755389 756202 756720 757751 758980 765029 774194 774215 776696 800759 812860 817645 818528 820804 ] |
||||||||||||||||||||||||||||||
|
15.40 ms (6.65%) |
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 812860 756202 757751 723764 741212 755389 758980 765029 774194 774215 728283 738259 744340 753333 756720 739959 743232 698385 719062 776696 800759 444453 475347 385750 45856 107606 403986 451573 499006 402848 443245 428881 442557 436608 444695 460852 460051 446656 517222 530996 494413 466656 558617 572765 560183 569440 580246 551293 565960 566579 570284 573817 653534 553964 564744 579261 584436 587039 598388 603980 588092 753752 389631 392605 427737 469164 476510 395646 465996 466002 466142 471481 478370 480788 430508 447244 463669 466676 470737 472106 403353 414220 420674 429939 457254 461013 476974 445272 512555 512597 520690 489376 489488 492841 494400 495557 498548 508563 532008 533418 485461 489439 494614 500436 513015 513767 521116 495023 499177 517941 528817 529424 386565 144252 395343 424975 817645 818528 820804 585108 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.20%) |
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 45856 107606 144252 385750 386565 389631 392605 395343 395646 402848 403353 403986 414220 420674 424975 427737 428881 429939 430508 436608 442557 443245 444453 444695 445272 446656 447244 451573 457254 460051 460852 461013 463669 465996 466002 466142 466656 466676 469164 470737 471481 472106 475347 476510 476974 478370 480788 485461 489376 489439 489488 492841 494400 494413 494614 495023 495557 498548 499006 499177 500436 508563 512555 512597 513015 513767 517222 517941 520690 521116 528817 529424 530996 532008 533418 551293 553964 558617 560183 564744 565960 566579 569440 570284 572765 573817 579261 580246 584436 585108 587039 588092 598388 603980 653534 698385 719062 723764 728283 738259 739959 741212 743232 744340 753333 753752 755389 756202 756720 757751 758980 765029 774194 774215 776696 800759 812860 817645 818528 820804 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful sexy"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая sexy"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая sexy"
]
|
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.