Query Metrics
7
Database Queries
7
Different statements
145.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.62 ms (83.58%) |
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 390908 467861 472320 530363 530559 533394 533555 534104 537583 537636 537740 537759 540698 541334 541587 541623 541699 541874 542188 542960 542961 544296 544455 544529 545109 549371 549976 550336 551915 556783 558776 559119 559120 562837 563875 566252 566502 567476 568005 571201 571244 571428 571679 573076 573104 573627 574244 577356 580256 581401 584221 598486 601347 603259 604069 605345 617768 620696 621705 624451 628172 628294 629182 631294 639189 639397 640147 642773 648633 649548 654006 659554 663320 669481 677459 680195 680497 680769 688524 689493 689740 690672 701524 703519 709225 710298 710876 711117 713197 715160 720048 730479 744111 745506 746832 747552 750158 753717 755110 756011 761268 771233 772940 774683 778216 779404 782306 786208 787905 790406 793117 795824 797663 803742 813862 814191 816842 816846 823505 827674 ] |
||||||||||||||||||||||||||||||
|
14.24 ms (9.79%) |
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 659554 562837 605345 628294 604069 533394 568005 558776 573104 711117 715160 573076 537740 713197 753717 629182 541334 566502 549976 551915 542960 703519 550336 556783 563875 603259 598486 642773 541623 816846 537583 537759 533555 648633 710876 639189 620696 639397 778216 790406 747552 755110 772940 786208 771233 744111 472320 549371 559120 581401 544455 566252 571679 580256 571201 621705 624451 541699 816842 823505 827674 540698 545109 680497 709225 663320 680769 689493 689740 567476 584221 640147 797663 746832 761268 710298 577356 541874 544529 571244 601347 813862 814191 467861 530363 530559 534104 537636 573627 677459 688524 690672 701524 649548 654006 669481 720048 628172 631294 774683 795824 803742 779404 793117 756011 730479 745506 750158 617768 782306 787905 390908 541587 544296 559119 571428 542961 542188 574244 680195 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (2.00%) |
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 390908 467861 472320 530363 530559 533394 533555 534104 537583 537636 537740 537759 540698 541334 541587 541623 541699 541874 542188 542960 542961 544296 544455 544529 545109 549371 549976 550336 551915 556783 558776 559119 559120 562837 563875 566252 566502 567476 568005 571201 571244 571428 571679 573076 573104 573627 574244 577356 580256 581401 584221 598486 601347 603259 604069 605345 617768 620696 621705 624451 628172 628294 629182 631294 639189 639397 640147 642773 648633 649548 654006 659554 663320 669481 677459 680195 680497 680769 688524 689493 689740 690672 701524 703519 709225 710298 710876 711117 713197 715160 720048 730479 744111 745506 746832 747552 750158 753717 755110 756011 761268 771233 772940 774683 778216 779404 782306 786208 787905 790406 793117 795824 797663 803742 813862 814191 816842 816846 823505 827674 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens film"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens фильм"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens фильм"
]
|
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.