Query Metrics
7
Database Queries
7
Different statements
156.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.44 ms (80.76%) |
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 418928 421326 423499 424527 425609 428147 428192 431442 437592 443150 448674 450814 450838 463777 471956 476176 478475 478528 482245 483309 486004 486711 488771 491963 491997 493471 494745 502813 506830 508526 509197 512188 512397 513156 514842 514996 515729 516003 517368 517723 519161 520673 521741 522086 522851 524284 530716 532922 532969 532978 533186 533831 533957 534228 536637 537122 550076 553039 561129 561132 568503 569927 570099 571236 571367 576658 580259 580388 585740 586136 589968 591292 595068 598106 598169 599882 600225 600302 601841 601887 603610 605637 610734 620160 623178 626546 628312 640525 642677 647995 652316 673583 678744 681137 681152 683582 692381 695184 704951 716623 718745 718766 725392 737089 752185 770337 775848 775967 782804 789694 797447 797949 809318 813265 814152 814908 815566 815648 816499 822693 ] |
||||||||||||||||||||||||||||||
|
19.61 ms (12.52%) |
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 752185 737089 491963 423499 437592 822693 814152 815566 471956 488771 463777 530716 532978 532969 537122 494745 508526 515729 532922 533186 493471 580259 580388 576658 673583 681152 704951 718766 678744 683582 716623 550076 571367 586136 642677 598169 620160 623178 585740 589968 595068 600302 640525 600225 605637 626546 809318 775967 782804 797447 789694 770337 813265 476176 421326 443150 478528 428147 448674 450814 450838 509197 520673 483309 506830 514842 522086 486004 486711 491997 502813 512188 516003 517723 512397 513156 521741 522851 424527 692381 533957 418928 425609 814908 815648 816499 482245 517368 514996 524284 533831 534228 536637 519161 561132 568503 571236 553039 561129 569927 718745 647995 652316 681137 695184 570099 591292 599882 601841 603610 628312 598106 601887 610734 797949 725392 775848 428192 431442 478475 ] |
||||||||||||||||||||||||||||||
|
3.18 ms (2.03%) |
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 418928 421326 423499 424527 425609 428147 428192 431442 437592 443150 448674 450814 450838 463777 471956 476176 478475 478528 482245 483309 486004 486711 488771 491963 491997 493471 494745 502813 506830 508526 509197 512188 512397 513156 514842 514996 515729 516003 517368 517723 519161 520673 521741 522086 522851 524284 530716 532922 532969 532978 533186 533831 533957 534228 536637 537122 550076 553039 561129 561132 568503 569927 570099 571236 571367 576658 580259 580388 585740 586136 589968 591292 595068 598106 598169 599882 600225 600302 601841 601887 603610 605637 610734 620160 623178 626546 628312 640525 642677 647995 652316 673583 678744 681137 681152 683582 692381 695184 704951 716623 718745 718766 725392 737089 752185 770337 775848 775967 782804 789694 797447 797949 809318 813265 814152 814908 815566 815648 816499 822693 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom bondage"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.01%) |
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.