Query Metrics
7
Database Queries
7
Different statements
671.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
233.60 ms (34.79%) |
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 21397 169962 185428 385890 388481 398733 400460 405551 415107 417750 418991 427092 428409 429247 439640 443593 443642 447296 451574 451590 451596 453130 456359 460126 460147 465991 472107 472305 472336 472337 472341 472343 475056 475204 475973 476378 476693 477574 481140 487133 489130 494690 494734 496976 510079 512688 516883 516997 520661 522677 522833 525526 525925 527517 528906 529074 540722 543498 543831 550067 551196 551267 551269 552686 557592 563611 565355 565364 567584 569877 569883 570028 570196 570221 570299 570357 570653 571537 571546 571922 572522 572806 573006 573360 574586 574817 575090 575109 575510 575514 576359 580054 589835 594931 611702 619135 624856 663255 666409 672417 673277 676330 685926 690480 691234 691547 704860 717243 726015 732472 743119 743447 745035 747403 754539 764099 777863 779867 798981 826882 ] |
||||||||||||||||||||||||||||||
|
210.57 ms (31.36%) |
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 21397 169962 185428 385890 388481 398733 400460 405551 415107 417750 418991 427092 428409 429247 439640 443593 443642 447296 451574 451590 451596 453130 456359 460126 460147 465991 472107 472305 472336 472337 472341 472343 475056 475204 475973 476378 476693 477574 481140 487133 489130 494690 494734 496976 510079 512688 516883 516997 520661 522677 522833 525526 525925 527517 528906 529074 540722 543498 543831 550067 551196 551267 551269 552686 557592 563611 565355 565364 567584 569877 569883 570028 570196 570221 570299 570357 570653 571537 571546 571922 572522 572806 573006 573360 574586 574817 575090 575109 575510 575514 576359 580054 589835 594931 611702 619135 624856 663255 666409 672417 673277 676330 685926 690480 691234 691547 704860 717243 726015 732472 743119 743447 745035 747403 754539 764099 777863 779867 798981 826882 ] |
||||||||||||||||||||||||||||||
|
205.85 ms (30.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пикапе в"
]
|
||||||||||||||||||||||||||||||
|
16.72 ms (2.49%) |
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 405551 512688 527517 551196 570299 571546 690480 685926 572522 477574 415107 525925 522833 169962 494734 570028 543498 571922 672417 21397 475973 385890 551267 398733 826882 569883 673277 691234 704860 717243 663255 666409 676330 691547 611702 619135 779867 798981 777863 743119 747403 754539 732472 764099 726015 745035 743447 624856 460147 185428 550067 570653 565364 557592 529074 443593 475056 575514 570221 575109 565355 589835 428409 439640 472341 475204 476693 460126 472336 528906 487133 510079 525526 489130 494690 496976 388481 418991 429247 451590 472305 516883 522677 572806 574586 574817 543831 552686 570196 573360 575090 575510 567584 551269 563611 569877 570357 571537 573006 576359 580054 594931 400460 417750 453130 476378 427092 451574 481140 451596 472343 447296 472337 443642 456359 465991 472107 516997 520661 540722 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пикап в"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.19%) |
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.