Query Metrics
7
Database Queries
7
Different statements
150.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.35 ms (82.39%) |
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 28892 50408 195768 381823 388642 392676 398306 402626 416000 416683 419022 419609 426284 428239 429892 435722 443257 447352 448593 454282 457071 471122 475302 483315 483732 483742 483777 486761 486767 488559 505345 515490 527922 529296 530124 530679 541570 545376 547467 554369 557621 558214 564285 564288 564480 566097 568652 574388 576590 584331 584481 585251 587451 589120 590169 590377 591482 594513 595158 601778 604884 607236 613690 617796 617817 623793 631728 648503 650145 650476 656200 657527 658797 658907 660410 662151 666969 666974 676416 679491 680484 686474 696584 697958 700042 703945 709917 712267 722520 738490 739113 742364 742681 746177 749697 751822 757226 758078 758322 759793 760538 762673 765172 778105 778808 781455 781865 781922 784052 784738 788360 793683 795390 797051 797326 803767 805295 808446 808548 824340 ] |
||||||||||||||||||||||||||||||
|
16.35 ms (10.83%) |
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 457071 471122 416683 426284 429892 483732 483742 402626 515490 527922 584481 554369 558214 658907 709917 658797 566097 595158 607236 585251 454282 419022 447352 488559 483315 381823 50408 824340 584331 557621 564480 648503 666974 696584 700042 712267 589120 591482 590169 601778 613690 604884 617817 623793 784052 797326 805295 758322 781865 793683 803767 808548 749697 760538 742364 746177 757226 738490 742681 758078 617796 703945 778808 795390 28892 435722 594513 505345 443257 545376 680484 590377 419609 541570 388642 416000 486767 547467 650476 660410 574388 486761 483777 530124 666969 686474 679491 788360 739113 765172 759793 781922 797051 398306 392676 762673 751822 195768 428239 475302 448593 529296 530679 564285 564288 650145 657527 722520 656200 662151 676416 697958 568652 576590 631728 587451 778105 781455 784738 808446 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.80%) |
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 28892 50408 195768 381823 388642 392676 398306 402626 416000 416683 419022 419609 426284 428239 429892 435722 443257 447352 448593 454282 457071 471122 475302 483315 483732 483742 483777 486761 486767 488559 505345 515490 527922 529296 530124 530679 541570 545376 547467 554369 557621 558214 564285 564288 564480 566097 568652 574388 576590 584331 584481 585251 587451 589120 590169 590377 591482 594513 595158 601778 604884 607236 613690 617796 617817 623793 631728 648503 650145 650476 656200 657527 658797 658907 660410 662151 666969 666974 676416 679491 680484 686474 696584 697958 700042 703945 709917 712267 722520 738490 739113 742364 742681 746177 749697 751822 757226 758078 758322 759793 760538 762673 765172 778105 778808 781455 781865 781922 784052 784738 788360 793683 795390 797051 797326 803767 805295 808446 808548 824340 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"порн большие дилд"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"порн большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"порно с большими дылд%…"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.09%) |
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.