Query Metrics
7
Database Queries
7
Different statements
253.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.24 ms (84.03%) |
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 12573 91248 389093 395550 397425 399737 402458 402969 407489 417318 418005 425474 426441 431979 439233 443590 445182 445872 446489 446508 452400 453829 455641 456936 457043 459326 462769 464518 465991 468190 471172 475772 478998 483814 486692 490786 492355 494058 499774 503117 514942 516024 516035 517793 523300 527711 528947 528950 528966 528970 529027 530480 533767 547731 548785 551183 551477 561306 567965 568251 570538 571924 573852 574508 577376 580307 580695 583984 585475 589761 590795 594505 594947 598798 599447 601524 608233 615400 617026 619762 630279 631187 633238 637025 637783 644321 659297 661287 704298 706930 707347 714050 715102 717543 717826 720445 720699 722190 724169 735130 738641 743137 744099 745725 747497 755109 755995 761155 761193 770532 773907 786330 786790 788272 792246 794331 797731 807301 812922 813285 ] |
||||||||||||||||||||||||||||||
|
28.20 ms (11.11%) |
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 704298 706930 714050 717543 720445 720699 722190 568251 585475 608233 637783 594947 633238 615400 590795 599447 630279 631187 786330 786790 813285 788272 792246 755995 773907 735130 747497 761155 761193 724169 755109 770532 743137 744099 794331 797731 12573 453829 617026 91248 425474 475772 446508 452400 514942 570538 707347 661287 717826 548785 551183 644321 738641 807301 397425 417318 395550 418005 426441 455641 465991 503117 483814 523300 457043 471172 527711 528947 528950 528966 528970 571924 574508 715102 598798 619762 745725 402969 529027 516035 492355 517793 601524 389093 499774 533767 494058 530480 637025 812922 462769 431979 445182 443590 490786 589761 402458 445872 468190 577376 583984 561306 659297 594505 456936 439233 516024 399737 407489 459326 486692 478998 464518 567965 573852 547731 580695 580307 551477 446489 ] |
||||||||||||||||||||||||||||||
|
4.76 ms (1.88%) |
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 12573 91248 389093 395550 397425 399737 402458 402969 407489 417318 418005 425474 426441 431979 439233 443590 445182 445872 446489 446508 452400 453829 455641 456936 457043 459326 462769 464518 465991 468190 471172 475772 478998 483814 486692 490786 492355 494058 499774 503117 514942 516024 516035 517793 523300 527711 528947 528950 528966 528970 529027 530480 533767 547731 548785 551183 551477 561306 567965 568251 570538 571924 573852 574508 577376 580307 580695 583984 585475 589761 590795 594505 594947 598798 599447 601524 608233 615400 617026 619762 630279 631187 633238 637025 637783 644321 659297 661287 704298 706930 707347 714050 715102 717543 717826 720445 720699 722190 724169 735130 738641 743137 744099 745725 747497 755109 755995 761155 761193 770532 773907 786330 786790 788272 792246 794331 797731 807301 812922 813285 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen public"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.