Query Metrics
7
Database Queries
7
Different statements
138.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.33 ms (84.80%) |
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 150785 324568 387050 413287 418862 420738 423463 423478 433364 441788 447149 449166 451165 452662 456579 464028 466568 468251 472957 478274 481587 482573 483451 483658 485835 487823 494931 495585 496781 500084 503408 503757 504767 507104 513855 513939 517083 517185 518762 520924 521101 522119 522721 523637 525146 525308 529442 530164 531549 532321 538042 543116 544265 545104 546392 546517 546849 547912 551114 552489 552937 553620 554404 555018 557344 559744 562929 564393 565760 566145 567591 569221 574643 575606 577250 577949 582182 584181 587446 589137 589837 591031 593452 596681 596931 599710 604356 605638 605825 608288 609296 613152 614395 618745 624408 637176 646052 658519 660050 672417 673575 678857 700513 707396 713473 714585 723092 725580 734317 736785 763182 765911 766265 777007 782847 783067 794763 796228 796769 800878 ] |
||||||||||||||||||||||||||||||
|
12.44 ms (8.99%) |
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 596931 796769 734317 765911 766265 713473 782847 423478 569221 796228 783067 324568 418862 468251 520924 503757 565760 546392 604356 551114 605825 587446 596681 660050 447149 507104 496781 543116 552489 672417 591031 637176 589137 589837 736785 483451 483658 441788 423463 420738 482573 481587 504767 531549 532321 495585 513855 554404 562929 566145 547912 546517 553620 646052 714585 552937 575606 582182 605638 614395 618745 593452 608288 725580 707396 723092 800878 150785 413287 449166 478274 513939 525308 433364 451165 456579 517185 518762 494931 559744 577949 658519 678857 546849 557344 777007 763182 472957 545104 487823 500084 567591 574643 613152 387050 538042 485835 544265 673575 700513 794763 452662 503408 517083 530164 525146 464028 555018 577250 584181 564393 599710 609296 624408 521101 466568 529442 522119 523637 522721 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.61%) |
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 150785 324568 387050 413287 418862 420738 423463 423478 433364 441788 447149 449166 451165 452662 456579 464028 466568 468251 472957 478274 481587 482573 483451 483658 485835 487823 494931 495585 496781 500084 503408 503757 504767 507104 513855 513939 517083 517185 518762 520924 521101 522119 522721 523637 525146 525308 529442 530164 531549 532321 538042 543116 544265 545104 546392 546517 546849 547912 551114 552489 552937 553620 554404 555018 557344 559744 562929 564393 565760 566145 567591 569221 574643 575606 577250 577949 582182 584181 587446 589137 589837 591031 593452 596681 596931 599710 604356 605638 605825 608288 609296 613152 614395 618745 624408 637176 646052 658519 660050 672417 673575 678857 700513 707396 713473 714585 723092 725580 734317 736785 763182 765911 766265 777007 782847 783067 794763 796228 796769 800878 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"стоя с зади"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сто жоп"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (1.01%) |
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.