Query Metrics
7
Database Queries
7
Different statements
191.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.73 ms (85.91%) |
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 79469 397075 398119 402969 415816 426624 427940 443280 449502 449517 450118 450155 450866 451879 452743 455244 455628 456589 457093 459477 459776 460534 462571 463386 463497 463807 467769 472020 485382 488466 489715 497174 500519 510415 514064 526880 527804 529802 542740 546849 555101 556504 561809 572956 579553 582121 586936 588508 590577 595111 620211 620547 620973 625189 626074 628638 650669 651716 659311 660089 663151 665678 675393 692073 692840 693327 694400 696070 698228 699581 701604 707886 709635 710346 716010 716628 722239 727593 727796 735481 737662 738562 738626 738844 740787 745374 747298 758512 759493 760942 761436 763060 766223 767354 769859 770958 771734 773761 778915 779262 779318 782302 783385 785443 786990 787887 789588 790256 790437 791298 791543 792700 794106 800730 804220 804878 807536 813034 825018 826295 ] |
||||||||||||||||||||||||||||||
|
15.63 ms (8.15%) |
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 807536 526880 460534 451879 463497 497174 488466 542740 716010 785443 737662 738844 727796 747298 787887 485382 692840 722239 738626 759493 738562 459776 826295 467769 716628 660089 659311 675393 628638 745374 767354 778915 804220 459477 825018 463386 579553 699581 650669 791298 790437 740787 735481 760942 79469 397075 452743 529802 707886 692073 696070 693327 620973 586936 782302 800730 763060 773761 766223 701604 710346 792700 450866 426624 443280 450155 472020 514064 651716 620547 758512 770958 727593 450118 510415 489715 449517 500519 813034 449502 626074 572956 620211 769859 779318 561809 588508 455628 463807 694400 698228 665678 709635 546849 582121 625189 761436 779262 783385 786990 398119 402969 456589 457093 555101 791543 771734 789588 804878 415816 427940 527804 462571 455244 556504 663151 590577 595111 790256 794106 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.62%) |
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 79469 397075 398119 402969 415816 426624 427940 443280 449502 449517 450118 450155 450866 451879 452743 455244 455628 456589 457093 459477 459776 460534 462571 463386 463497 463807 467769 472020 485382 488466 489715 497174 500519 510415 514064 526880 527804 529802 542740 546849 555101 556504 561809 572956 579553 582121 586936 588508 590577 595111 620211 620547 620973 625189 626074 628638 650669 651716 659311 660089 663151 665678 675393 692073 692840 693327 694400 696070 698228 699581 701604 707886 709635 710346 716010 716628 722239 727593 727796 735481 737662 738562 738626 738844 740787 745374 747298 758512 759493 760942 761436 763060 766223 767354 769859 770958 771734 773761 778915 779262 779318 782302 783385 785443 786990 787887 789588 790256 790437 791298 791543 792700 794106 800730 804220 804878 807536 813034 825018 826295 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck to cum"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс cum"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс cum"
]
|
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.