Query Metrics
7
Database Queries
7
Different statements
159.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.33 ms (81.72%) |
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 166675 404280 413938 415451 419160 424671 425559 427326 439685 440686 442463 443801 444702 446737 451100 451629 455333 457742 457792 458469 462123 463191 464598 465996 468483 469044 469172 473463 474777 478983 478985 483453 485258 485666 489649 490517 491299 491631 492318 497585 499751 500013 502868 505039 506533 508420 510597 513466 517885 524217 524639 526261 527515 527711 535626 539561 542984 548618 554374 554723 557810 558618 562371 564408 569629 572681 578803 580642 582589 589211 589224 592616 596274 600436 607023 610121 612268 620115 623250 630098 630716 630731 639845 641445 643194 658208 658222 658223 658224 658225 658226 672766 692169 693778 694203 695786 707569 709874 709961 714948 716085 718044 719423 721249 721867 730644 732905 734383 737628 738245 742235 760169 761899 790136 794416 809592 814129 815855 819613 822212 ] |
||||||||||||||||||||||||||||||
|
17.72 ms (11.11%) |
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 694203 719423 693778 695786 639845 809592 790136 734383 630098 707569 596274 474777 469044 483453 458469 508420 457792 630731 485666 578803 709874 692169 554374 557810 572681 589224 607023 643194 732905 716085 492318 527515 542984 589211 592616 623250 641445 478985 465996 462123 510597 513466 485258 526261 419160 425559 427326 446737 457742 468483 582589 464598 404280 473463 524217 469172 742235 517885 490517 524639 562371 580642 760169 439685 443801 455333 491299 502868 489649 497585 500013 569629 600436 442463 413938 815855 822212 819613 499751 548618 558618 564408 658208 658222 721249 658224 672766 709961 718044 658223 658225 658226 714948 721867 610121 612268 630716 620115 794416 737628 730644 738245 761899 491631 424671 444702 440686 451100 539561 463191 505039 166675 415451 814129 451629 478983 527711 535626 506533 554723 ] |
||||||||||||||||||||||||||||||
|
3.92 ms (2.46%) |
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 166675 404280 413938 415451 419160 424671 425559 427326 439685 440686 442463 443801 444702 446737 451100 451629 455333 457742 457792 458469 462123 463191 464598 465996 468483 469044 469172 473463 474777 478983 478985 483453 485258 485666 489649 490517 491299 491631 492318 497585 499751 500013 502868 505039 506533 508420 510597 513466 517885 524217 524639 526261 527515 527711 535626 539561 542984 548618 554374 554723 557810 558618 562371 564408 569629 572681 578803 580642 582589 589211 589224 592616 596274 600436 607023 610121 612268 620115 623250 630098 630716 630731 639845 641445 643194 658208 658222 658223 658224 658225 658226 672766 692169 693778 694203 695786 707569 709874 709961 714948 716085 718044 719423 721249 721867 730644 732905 734383 737628 738245 742235 760169 761899 790136 794416 809592 814129 815855 819613 822212 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие real сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big real tits"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие real сиськ"
]
|
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.