Query Metrics
7
Database Queries
7
Different statements
150.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.22 ms (79.21%) |
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 4252 12680 30791 71071 150488 188335 233941 235816 308583 381952 384589 385379 385386 385638 387407 389819 394109 396001 396379 397190 398965 400691 402340 407187 407409 411069 411249 416116 416120 419549 424102 425510 425526 426870 427001 427208 428580 430566 435366 440942 441780 443081 443135 443419 444233 444707 448925 449411 453397 457558 458193 459325 459418 460171 463204 465579 465653 466465 466756 466923 468284 468376 468518 470035 471570 472373 472772 473319 475097 475887 476312 478079 478611 478803 478937 479123 480892 480931 481101 481750 483723 485610 485986 488843 489172 490574 490708 491158 493087 495206 495726 495814 496019 498210 500095 503515 503877 505342 507955 508304 509199 509202 514887 521439 522163 534191 543856 565872 567750 577097 588435 619774 622127 626580 636450 655088 677132 690438 697704 710191 ] |
||||||||||||||||||||||||||||||
|
17.70 ms (11.76%) |
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 459325 485610 509199 503515 495206 514887 488843 543856 567750 577097 677132 588435 308583 385379 396001 411249 425526 471570 472772 233941 394109 448925 465579 466923 71071 384589 400691 426870 235816 385386 416116 458193 478611 509202 485986 489172 498210 495814 521439 505342 385638 150488 381952 30791 4252 12680 389819 397190 416120 430566 411069 443135 443419 444707 407187 443081 444233 427208 428580 440942 441780 457558 459418 465653 468284 475097 476312 483723 490574 490708 449411 468376 470035 480931 491158 495726 522163 534191 496019 503877 507955 475887 481101 493087 565872 690438 655088 697704 710191 626580 636450 619774 622127 188335 396379 419549 460171 473319 398965 402340 424102 427001 435366 463204 466756 479123 407409 425510 453397 478937 387407 468518 478803 480892 466465 472373 478079 481750 508304 500095 ] |
||||||||||||||||||||||||||||||
|
4.45 ms (2.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вес"
]
|
||||||||||||||||||||||||||||||
|
3.06 ms (2.04%) |
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 4252 12680 30791 71071 150488 188335 233941 235816 308583 381952 384589 385379 385386 385638 387407 389819 394109 396001 396379 397190 398965 400691 402340 407187 407409 411069 411249 416116 416120 419549 424102 425510 425526 426870 427001 427208 428580 430566 435366 440942 441780 443081 443135 443419 444233 444707 448925 449411 453397 457558 458193 459325 459418 460171 463204 465579 465653 466465 466756 466923 468284 468376 468518 470035 471570 472373 472772 473319 475097 475887 476312 478079 478611 478803 478937 479123 480892 480931 481101 481750 483723 485610 485986 488843 489172 490574 490708 491158 493087 495206 495726 495814 496019 498210 500095 503515 503877 505342 507955 508304 509199 509202 514887 521439 522163 534191 543856 565872 567750 577097 588435 619774 622127 626580 636450 655088 677132 690438 697704 710191 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"весу"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.