Query Metrics
7
Database Queries
7
Different statements
155.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.20 ms (83.67%) |
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 43207 84130 378256 382844 383952 384574 384905 387000 396881 398000 398976 400593 401877 404491 406648 411498 412183 416878 417739 417746 421816 421899 422282 426571 427561 427819 427898 427912 429869 430088 431484 431501 437961 442810 443412 443782 446086 447554 448701 450800 454081 454819 459840 463222 467478 469242 474093 483087 485969 499027 499296 502603 506000 511794 517039 517535 518484 520162 520676 521727 522989 523248 527565 531347 532334 532563 533340 534463 535309 535931 537391 539593 545788 546112 546640 548844 549105 549222 551932 554448 554449 554542 554914 555285 555402 555435 557089 557327 557892 558755 559841 560885 561283 561918 563431 563619 565749 571664 574047 574630 575703 576680 578493 578790 583933 587866 589697 591463 591566 592719 594212 605855 606162 613851 623487 623922 624664 649100 664289 677147 ] |
||||||||||||||||||||||||||||||
|
14.37 ms (9.23%) |
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 527565 613851 623922 427898 383952 387000 84130 623487 499296 531347 549222 551932 554448 554542 555402 557327 558755 554449 555435 563431 578790 561283 583933 589697 454081 546112 421816 459840 448701 401877 384905 398976 400593 43207 398000 417739 427561 437961 442810 454819 474093 506000 502603 469242 555285 605855 606162 591566 587866 591463 594212 624664 427819 421899 426571 429869 467478 406648 416878 447554 411498 443782 450800 382844 378256 384574 396881 404491 417746 422282 431501 427912 443412 431484 412183 430088 463222 446086 483087 517039 518484 532334 535309 539593 534463 520162 520676 521727 522989 532563 533340 535931 537391 499027 511794 517535 523248 485969 571664 574047 578493 548844 557892 560885 576680 545788 549105 554914 557089 561918 563619 565749 575703 649100 664289 677147 546640 559841 574630 592719 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.96%) |
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 43207 84130 378256 382844 383952 384574 384905 387000 396881 398000 398976 400593 401877 404491 406648 411498 412183 416878 417739 417746 421816 421899 422282 426571 427561 427819 427898 427912 429869 430088 431484 431501 437961 442810 443412 443782 446086 447554 448701 450800 454081 454819 459840 463222 467478 469242 474093 483087 485969 499027 499296 502603 506000 511794 517039 517535 518484 520162 520676 521727 522989 523248 527565 531347 532334 532563 533340 534463 535309 535931 537391 539593 545788 546112 546640 548844 549105 549222 551932 554448 554449 554542 554914 555285 555402 555435 557089 557327 557892 558755 559841 560885 561283 561918 563431 563619 565749 571664 574047 574630 575703 576680 578493 578790 583933 587866 589697 591463 591566 592719 594212 605855 606162 613851 623487 623922 624664 649100 664289 677147 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"большие задници волос…"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп волос"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.08%) |
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.