Query Metrics
7
Database Queries
7
Different statements
181.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.80 ms (85.75%) |
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 96443 207775 230399 249590 249788 349193 365954 381785 382054 382543 384384 385528 385760 386263 387007 390133 390252 396384 396430 396528 397075 397224 397981 398918 400754 401804 401859 405903 409196 409621 410739 411151 414092 415254 417279 419173 420749 423611 424497 425590 426028 426326 426395 426933 427268 428366 429066 429193 430043 436642 442623 443164 443710 443938 444442 444778 446350 448652 453652 454503 454900 458045 458441 459443 461085 464208 468485 470260 470747 470816 471110 471533 476635 479308 480201 488231 488924 489478 495564 498378 501597 502999 504262 504711 506486 507150 509519 510664 510822 512087 512642 513161 525714 526557 533464 550237 552228 559365 565527 570218 572621 573702 575761 592061 603956 610688 619727 652949 663973 667581 667672 667863 681170 681216 710587 715480 738247 753221 790047 800575 ] |
||||||||||||||||||||||||||||||
|
16.47 ms (9.07%) |
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 409621 506486 382054 387007 390133 397224 397981 401859 427268 429066 444442 417279 443938 453652 488231 495564 504711 502999 476635 552228 559365 652949 667581 681170 667863 619727 592061 753221 738247 790047 382543 415254 398918 425590 448652 454503 470816 386263 423611 461085 471110 230399 249590 400754 411151 458441 470747 498378 509519 512642 489478 513161 385760 249788 396430 396528 397075 405903 436642 442623 429193 426395 410739 409196 424497 470260 488924 446350 533464 510822 550237 573702 565527 570218 575761 663973 681216 710587 715480 667672 572621 610688 603956 800575 207775 349193 381785 390252 443710 454900 479308 426028 384384 96443 365954 414092 426326 430043 459443 464208 512087 501597 504262 510664 525714 507150 526557 385528 396384 401804 444778 419173 420749 426933 428366 443164 458045 471533 480201 468485 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.42%) |
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 96443 207775 230399 249590 249788 349193 365954 381785 382054 382543 384384 385528 385760 386263 387007 390133 390252 396384 396430 396528 397075 397224 397981 398918 400754 401804 401859 405903 409196 409621 410739 411151 414092 415254 417279 419173 420749 423611 424497 425590 426028 426326 426395 426933 427268 428366 429066 429193 430043 436642 442623 443164 443710 443938 444442 444778 446350 448652 453652 454503 454900 458045 458441 459443 461085 464208 468485 470260 470747 470816 471110 471533 476635 479308 480201 488231 488924 489478 495564 498378 501597 502999 504262 504711 506486 507150 509519 510664 510822 512087 512642 513161 525714 526557 533464 550237 552228 559365 565527 570218 572621 573702 575761 592061 603956 610688 619727 652949 663973 667581 667672 667863 681170 681216 710587 715480 738247 753221 790047 800575 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худой"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с худой"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.85%) |
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.