Query Metrics
7
Database Queries
7
Different statements
212.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.29 ms (88.16%) |
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 358410 381803 411285 429699 441025 452829 454726 459375 466476 489286 510945 513380 531332 532778 532830 533655 541708 542757 546409 557462 579872 582842 585409 590035 590692 591963 592855 598797 601375 602888 604302 604340 605819 608295 613035 617778 619205 619286 620907 620979 623191 624156 626686 631522 632935 633650 634027 635061 636496 642534 646002 648455 654901 654909 656284 656812 659960 664461 668331 670900 670902 675612 680282 680291 683649 684400 685288 686139 686737 686924 687810 689233 690934 693509 695876 697458 699976 704264 704677 705212 714314 717197 720017 724059 726181 726327 728373 738483 748487 748971 757906 759874 765718 766768 768341 770282 773268 776026 779665 782122 784956 787567 788557 790494 791246 794366 794909 794914 797194 810387 819269 823740 824425 824679 825733 826046 826154 827490 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (6.96%) |
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 531332 546409 582842 557462 656812 659960 675612 670902 683649 684400 686139 687810 705212 654909 664461 670900 680291 695876 697458 704677 613035 626686 635061 601375 605819 636496 590035 591963 619205 620907 632935 633650 590692 592855 604302 604340 794914 797194 726327 728373 608295 617778 704264 714314 533655 825733 810387 693509 790494 631522 358410 510945 648455 646002 532830 598797 738483 466476 624156 532778 454726 459375 489286 686737 685288 690934 791246 759874 381803 452829 656284 689233 699976 686924 720017 642534 620979 623191 585409 726181 748971 724059 542757 619286 757906 441025 429699 411285 513380 826046 826154 819269 823740 824425 824679 827490 717197 776026 784956 794366 794309 766768 787567 748487 768341 773268 744999 765718 770282 779665 788557 541708 579872 634027 602888 782122 794909 680282 654901 668331 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal webcam amateur"
]
|
||||||||||||||||||||||||||||||
|
2.67 ms (1.26%) |
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 358410 381803 411285 429699 441025 452829 454726 459375 466476 489286 510945 513380 531332 532778 532830 533655 541708 542757 546409 557462 579872 582842 585409 590035 590692 591963 592855 598797 601375 602888 604302 604340 605819 608295 613035 617778 619205 619286 620907 620979 623191 624156 626686 631522 632935 633650 634027 635061 636496 642534 646002 648455 654901 654909 656284 656812 659960 664461 668331 670900 670902 675612 680282 680291 683649 684400 685288 686139 686737 686924 687810 689233 690934 693509 695876 697458 699976 704264 704677 705212 714314 717197 720017 724059 726181 726327 728373 738483 748487 748971 757906 759874 765718 766768 768341 770282 773268 776026 779665 782122 784956 787567 788557 790494 791246 794366 794909 794914 797194 810387 819269 823740 824425 824679 825733 826046 826154 827490 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал вебкамер любительск"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.67%) |
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.