Query Metrics
7
Database Queries
7
Different statements
280.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
255.21 ms (90.84%) |
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 212963 233320 382341 383031 388177 388522 389067 395517 415781 422034 423840 425554 432854 451074 452178 452334 453214 459077 460348 461893 463725 464503 467600 469673 470321 472322 473244 474509 475369 479260 479286 486444 486630 488928 490638 493472 498056 498181 498672 500086 503804 505878 505916 508480 510571 512932 513027 517084 518379 518452 518593 519574 520366 520771 521598 522575 523908 525844 526807 527874 530548 533950 533961 537710 538355 544344 551446 553320 555216 556584 557105 557384 557573 559753 560553 560654 566592 567681 567890 568748 569118 571579 571689 577663 580533 582380 586050 586791 591183 593917 596503 597115 598703 603982 609042 614024 619040 620646 622408 624160 625906 628811 630955 635574 636134 636509 641004 645920 660905 660923 694508 706401 711011 718158 732947 735223 735495 754649 792379 794330 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (5.49%) |
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 389067 620646 530548 571689 559753 382341 526807 503804 513027 388177 473244 472322 553320 571579 636134 603982 586791 464503 423840 463725 510571 622408 233320 635574 475369 490638 518452 555216 567890 580533 609042 586050 593917 469673 432854 794330 395517 538355 660923 694508 735223 711011 518379 460348 519574 533961 517084 505916 560553 567681 569118 624160 498672 522575 505878 512932 625906 614024 212963 479286 488928 636509 470321 525844 452334 551446 582380 557573 425554 508480 498181 660905 566592 415781 474509 451074 521598 577663 597115 641004 630955 467600 453214 527874 422034 628811 383031 718158 792379 533950 537710 754649 461893 493472 568748 557105 596503 619040 598703 479260 520366 498056 486444 452178 520771 645920 486630 459077 557384 388522 560654 500086 556584 706401 591183 735495 544344 518593 523908 732947 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.18%) |
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 212963 233320 382341 383031 388177 388522 389067 395517 415781 422034 423840 425554 432854 451074 452178 452334 453214 459077 460348 461893 463725 464503 467600 469673 470321 472322 473244 474509 475369 479260 479286 486444 486630 488928 490638 493472 498056 498181 498672 500086 503804 505878 505916 508480 510571 512932 513027 517084 518379 518452 518593 519574 520366 520771 521598 522575 523908 525844 526807 527874 530548 533950 533961 537710 538355 544344 551446 553320 555216 556584 557105 557384 557573 559753 560553 560654 566592 567681 567890 568748 569118 571579 571689 577663 580533 582380 586050 586791 591183 593917 596503 597115 598703 603982 609042 614024 619040 620646 622408 624160 625906 628811 630955 635574 636134 636509 641004 645920 660905 660923 694508 706401 711011 718158 732947 735223 735495 754649 792379 794330 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс в"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебут в эту"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.56%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.56%) |
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.