Query Metrics
7
Database Queries
7
Different statements
155.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.90 ms (82.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 373859 378035 399705 399930 400469 400723 402789 403293 411842 413109 413426 413707 414760 414799 414974 415090 417722 418978 421633 422623 422925 423271 423540 423767 426138 427378 429345 429873 444198 444938 445082 446252 459234 459801 461306 463665 466916 468274 470181 470299 471821 475750 479473 479946 482075 483531 484846 485161 489042 490771 494111 494426 496448 496940 498852 499502 501036 502110 505230 506807 511233 513505 515821 516777 521779 523268 523653 524052 528004 529262 529445 545717 547877 551167 552326 552903 555742 555812 557984 560587 560938 561818 563880 565331 568098 570004 570010 573327 573834 573910 574609 574783 574825 574880 575524 576085 576097 578461 581901 581959 583240 585599 586835 587863 589108 590431 594790 594893 602495 605984 607154 613426 624762 651561 659594 659803 740187 789399 810706 ] |
||||||||||||||||||||||||||||||
|
16.88 ms (10.84%) |
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 475750 573910 574880 574825 576097 573834 399930 468274 479946 400469 413426 494111 502110 516777 529262 413707 511233 490771 521779 573327 651561 555812 605984 587863 607154 373859 659803 659594 602495 740187 764819 506807 585599 789399 560938 560587 547877 594893 471821 513505 403293 586835 590431 613426 414760 426138 444198 545717 463665 524052 624762 378035 399705 422623 444938 423540 415090 446252 552326 555742 565331 576085 578461 551167 557984 568098 575524 594790 414799 421633 422925 423767 470181 470299 445082 417722 496940 499502 523268 484846 489042 505230 515821 583240 570004 418978 429873 429345 485161 459234 581959 563880 561818 581901 589108 414974 466916 479473 423271 483531 494426 496448 498852 501036 523653 528004 529445 552903 411842 413109 402789 461306 570010 574783 574609 810706 427378 400723 482075 459801 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.76%) |
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 373859 378035 399705 399930 400469 400723 402789 403293 411842 413109 413426 413707 414760 414799 414974 415090 417722 418978 421633 422623 422925 423271 423540 423767 426138 427378 429345 429873 444198 444938 445082 446252 459234 459801 461306 463665 466916 468274 470181 470299 471821 475750 479473 479946 482075 483531 484846 485161 489042 490771 494111 494426 496448 496940 498852 499502 501036 502110 505230 506807 511233 513505 515821 516777 521779 523268 523653 524052 528004 529262 529445 545717 547877 551167 552326 552903 555742 555812 557984 560587 560938 561818 563880 565331 568098 570004 570010 573327 573834 573910 574609 574783 574825 574880 575524 576085 576097 578461 581901 581959 583240 585599 586835 587863 589108 590431 594790 594893 602495 605984 607154 613426 624762 651561 659594 659803 740187 789399 810706 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в рот худую"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в рот худая"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"в рот худая"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.