Query Metrics
7
Database Queries
7
Different statements
200.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.61 ms (85.46%) |
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 383748 385334 391574 392601 396287 398227 411765 415873 421215 423042 423199 429820 442836 443831 447308 457182 460756 462508 462597 464538 466706 466885 466976 467062 467100 467484 467507 469380 470532 472624 473154 473837 474034 474114 475704 478829 479031 482188 482992 484203 484373 484401 484402 484546 484696 484776 484856 485934 487340 487928 492779 493387 497583 498697 500190 502702 502857 503535 504271 512459 515732 516485 516653 516976 517496 517557 518577 518833 518859 518867 519148 519270 520864 520903 521977 523607 523784 525490 526329 527253 532352 532893 533613 534733 537848 542648 546371 548057 549227 549249 550236 564813 565119 577357 592512 596807 597123 603236 603691 604383 606771 611365 615517 619397 623982 632626 650326 697229 711297 717929 718928 731777 733587 748251 770896 782427 802781 807976 807991 810061 ] |
||||||||||||||||||||||||||||||
|
17.85 ms (8.89%) |
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 711297 782427 807991 411765 423199 447308 392601 429820 462508 462597 415873 503535 484776 484402 467507 475704 443831 460756 442836 467100 532352 564813 697229 484856 497583 533613 466885 484696 385334 396287 398227 423042 473154 464538 466706 469380 485934 484203 484546 516976 519270 523607 537848 500190 517557 519148 512459 523784 526329 534733 498697 466976 487340 549227 549249 550236 565119 717929 718928 548057 597123 606771 619397 615517 596807 603691 611365 592512 623982 632626 802781 748251 731777 733587 770896 604383 807976 810061 482188 467062 470532 479031 516485 493387 502857 484373 482992 515732 518859 520864 532893 542648 577357 650326 603236 478829 520903 521977 504271 492779 383748 391574 421215 467484 457182 472624 473837 474114 484401 474034 487928 518833 525490 516653 517496 518577 502702 527253 518867 546371 ] |
||||||||||||||||||||||||||||||
|
3.96 ms (1.97%) |
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 383748 385334 391574 392601 396287 398227 411765 415873 421215 423042 423199 429820 442836 443831 447308 457182 460756 462508 462597 464538 466706 466885 466976 467062 467100 467484 467507 469380 470532 472624 473154 473837 474034 474114 475704 478829 479031 482188 482992 484203 484373 484401 484402 484546 484696 484776 484856 485934 487340 487928 492779 493387 497583 498697 500190 502702 502857 503535 504271 512459 515732 516485 516653 516976 517496 517557 518577 518833 518859 518867 519148 519270 520864 520903 521977 523607 523784 525490 526329 527253 532352 532893 533613 534733 537848 542648 546371 548057 549227 549249 550236 564813 565119 577357 592512 596807 597123 603236 603691 604383 606771 611365 615517 619397 623982 632626 650326 697229 711297 717929 718928 731777 733587 748251 770896 782427 802781 807976 807991 810061 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short hair redhead"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short hair рыжая"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short hair рыжая"
]
|
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.