Query Metrics
7
Database Queries
7
Different statements
196.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.17 ms (87.07%) |
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 16851 198609 385285 413070 418225 420717 421740 421814 421882 424237 424259 427543 428059 428702 429880 432538 432611 432639 433686 438446 439645 439731 439743 439793 440440 440490 440593 440822 440876 442469 443210 447917 448953 454468 455987 456328 457418 457680 460924 461294 461406 462226 462253 463468 464116 464226 464987 465361 466762 469177 470400 475568 475872 477797 478385 480899 486854 488535 488556 492758 493528 493568 495088 495224 498112 503083 504875 511855 513538 513694 513725 516171 516780 518004 520811 523113 526663 528535 534119 535454 552837 553972 558220 558622 563646 565863 570876 571762 576548 577051 585400 588684 588992 590288 590783 603834 609164 612404 612601 616864 626385 629428 647105 660110 701654 709524 727024 735902 737925 745960 758572 761758 762383 765701 767782 788606 789440 796203 802012 809307 ] |
||||||||||||||||||||||||||||||
|
15.86 ms (8.07%) |
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 558220 469177 480899 420717 475872 470400 576548 761758 765701 788606 737925 762383 486854 447917 432611 428702 488535 413070 493528 609164 198609 571762 585400 603834 809307 727024 758572 745960 802012 498112 440593 442469 565863 438446 518004 520811 626385 464226 385285 796203 421882 440876 558622 495224 429880 457418 528535 629428 789440 767782 421740 462226 735902 461294 432538 455987 516171 552837 464987 493568 570876 443210 463468 513725 523113 457680 616864 418225 440490 462253 464116 433686 461406 475568 503083 504875 466762 456328 516780 488556 577051 424237 535454 427543 709524 513694 477797 590783 432639 440822 424259 439793 590288 511855 612404 492758 660110 454468 495088 563646 534119 612601 647105 701654 553972 588684 440440 16851 513538 526663 478385 588992 439743 448953 439731 465361 439645 460924 428059 421814 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.31%) |
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 16851 198609 385285 413070 418225 420717 421740 421814 421882 424237 424259 427543 428059 428702 429880 432538 432611 432639 433686 438446 439645 439731 439743 439793 440440 440490 440593 440822 440876 442469 443210 447917 448953 454468 455987 456328 457418 457680 460924 461294 461406 462226 462253 463468 464116 464226 464987 465361 466762 469177 470400 475568 475872 477797 478385 480899 486854 488535 488556 492758 493528 493568 495088 495224 498112 503083 504875 511855 513538 513694 513725 516171 516780 518004 520811 523113 526663 528535 534119 535454 552837 553972 558220 558622 563646 565863 570876 571762 576548 577051 585400 588684 588992 590288 590783 603834 609164 612404 612601 616864 626385 629428 647105 660110 701654 709524 727024 735902 737925 745960 758572 761758 762383 765701 767782 788606 789440 796203 802012 809307 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мамки в белье домашнее"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин в бел домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.76%) |
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.