Query Metrics
7
Database Queries
7
Different statements
162.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.14 ms (78.24%) |
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 341802 389895 396538 401064 402715 408365 410520 416244 420022 420654 428158 428830 428959 429906 430815 433993 436462 442808 448046 448052 450372 451799 453348 454074 454080 454274 459673 461869 462367 468109 469989 472626 475662 475688 476287 478844 483113 488123 489060 496548 502841 505399 505584 512224 512962 516602 520180 521203 523184 525132 527923 528271 528443 532943 535372 536527 542754 543614 546124 549128 549652 551115 552702 554388 558411 560490 561577 561999 563634 568972 571303 571762 574381 574406 574457 575194 579876 580966 583835 583954 584111 584602 585400 589256 589573 589670 590133 590289 590702 592460 592478 593139 596693 597123 598416 599257 600401 601731 603342 605404 606596 606655 607630 613300 617620 621574 627598 630475 645883 646895 650615 663988 678800 681161 683237 741688 741726 741739 741749 802905 ] |
||||||||||||||||||||||||||||||
|
25.06 ms (15.43%) |
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 681161 448046 523184 650615 590133 605404 408365 603342 741688 741739 741749 475688 488123 451799 428959 512962 433993 527923 402715 489060 420022 561577 590289 436462 592460 590702 430815 468109 450372 512224 571762 606596 585400 574381 461869 505399 613300 428158 525132 459673 502841 561999 592478 496548 528443 542754 645883 600401 568972 448052 420654 551115 596693 589573 599257 552702 428830 528271 536527 574406 606655 617620 678800 663988 476287 558411 554388 532943 469989 597123 535372 549652 802905 583954 593139 621574 589256 516602 396538 584602 543614 579876 580966 646895 454274 410520 630475 454080 478844 475662 549128 560490 574457 598416 589670 601731 627598 429906 571303 607630 546124 472626 442808 462367 520180 583835 741726 453348 416244 563634 575194 505584 483113 389895 454074 683237 401064 341802 521203 584111 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (2.19%) |
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 341802 389895 396538 401064 402715 408365 410520 416244 420022 420654 428158 428830 428959 429906 430815 433993 436462 442808 448046 448052 450372 451799 453348 454074 454080 454274 459673 461869 462367 468109 469989 472626 475662 475688 476287 478844 483113 488123 489060 496548 502841 505399 505584 512224 512962 516602 520180 521203 523184 525132 527923 528271 528443 532943 535372 536527 542754 543614 546124 549128 549652 551115 552702 554388 558411 560490 561577 561999 563634 568972 571303 571762 574381 574406 574457 575194 579876 580966 583835 583954 584111 584602 585400 589256 589573 589670 590133 590289 590702 592460 592478 593139 596693 597123 598416 599257 600401 601731 603342 605404 606596 606655 607630 613300 617620 621574 627598 630475 645883 646895 650615 663988 678800 681161 683237 741688 741726 741739 741749 802905 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел большие соск"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"чулки большие соски"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.86%) |
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.