Query Metrics
7
Database Queries
7
Different statements
154.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.76 ms (84.16%) |
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 388213 395520 398225 409984 410193 413262 417716 452218 456873 457073 465435 465437 467784 472966 507141 521447 530680 531868 531955 533179 534677 535603 539983 542322 544454 545323 546820 546825 550165 550575 554046 554668 558531 558612 560502 561629 563132 564860 565826 570890 574630 578133 579455 580695 581004 581621 584363 585475 589746 593280 594856 594872 607025 614212 618657 622011 622036 623939 625819 627894 641444 644905 646442 667230 672740 675349 685527 687304 695671 701204 705779 706900 707281 716361 717060 718015 718391 719062 720428 735375 736460 736489 739950 741239 742576 746012 754214 759098 768017 768460 768503 769725 775203 779644 784252 785136 789062 798169 798821 798842 802122 802917 808295 810803 815580 816054 816202 816846 816856 817472 817506 817549 817777 817876 817879 819509 819535 821027 823121 823592 ] |
||||||||||||||||||||||||||||||
|
13.03 ms (8.45%) |
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 545323 646442 706900 614212 618657 623939 594856 746012 736460 759098 742576 705779 779644 810803 456873 550165 585475 593280 589746 775203 672740 564860 398225 817879 821027 644905 817549 817876 819535 823121 539983 507141 530680 534677 531955 535603 472966 546825 554668 560502 570890 581004 584363 542322 546820 554046 558612 563132 581621 687304 717060 718391 718015 720428 627894 607025 754214 789062 768460 739950 769725 741239 768503 622011 625819 719062 785136 465437 467784 580695 413262 417716 457073 533179 565826 701204 667230 685527 695671 558531 578133 784252 802122 736489 409984 716361 675349 622036 735375 395520 531868 550575 579455 707281 594872 641444 798169 798821 808295 802917 768017 798842 465435 410193 388213 452218 521447 544454 561629 574630 816202 816856 816054 816846 817472 817506 819509 823592 815580 817777 ] |
||||||||||||||||||||||||||||||
|
3.54 ms (2.30%) |
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 388213 395520 398225 409984 410193 413262 417716 452218 456873 457073 465435 465437 467784 472966 507141 521447 530680 531868 531955 533179 534677 535603 539983 542322 544454 545323 546820 546825 550165 550575 554046 554668 558531 558612 560502 561629 563132 564860 565826 570890 574630 578133 579455 580695 581004 581621 584363 585475 589746 593280 594856 594872 607025 614212 618657 622011 622036 623939 625819 627894 641444 644905 646442 667230 672740 675349 685527 687304 695671 701204 705779 706900 707281 716361 717060 718015 718391 719062 720428 735375 736460 736489 739950 741239 742576 746012 754214 759098 768017 768460 768503 769725 775203 779644 784252 785136 789062 798169 798821 798842 802122 802917 808295 810803 815580 816054 816202 816846 816856 817472 817506 817549 817777 817876 817879 819509 819535 821027 823121 823592 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs in public"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs на улиц"
]
|
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.