Query Metrics
7
Database Queries
7
Different statements
207.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.60 ms (84.83%) |
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 182686 188560 385390 387749 390615 401768 401769 401810 412855 413392 414253 414595 416174 416583 416614 416676 431439 454368 454590 454804 464497 467584 467636 468148 469221 471117 471128 475504 476053 476658 480255 480258 500313 508759 513830 516611 522639 529617 530402 530688 531580 531834 531839 534545 534563 536129 540868 545453 545459 558455 561019 564271 566775 567063 568501 574377 577038 586113 589408 589526 594143 600144 602329 609920 612091 614957 616236 618259 634109 640081 640353 648704 652788 654978 658816 660369 660380 660394 666854 668305 669062 671002 671020 671038 672944 672952 677640 686830 693398 697108 705378 710434 738468 741684 749672 750145 751314 752592 752630 752669 756779 769364 771887 777752 782047 784701 785109 786904 789234 791871 792726 796685 800318 804000 806834 807170 807560 810870 814140 ] |
||||||||||||||||||||||||||||||
|
21.08 ms (10.18%) |
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 530688 558455 566775 677640 686830 693398 710434 652788 654978 589526 616236 640081 618259 640353 777752 786904 796685 807170 782047 789234 800318 807560 810870 751314 738468 750145 752592 756779 769364 697108 705378 791871 804000 508759 814140 476658 531580 545453 568501 671002 648704 660394 671020 658816 668305 634109 602329 784701 792726 752669 741684 749672 752630 806834 390615 454368 182686 387749 614957 630427 385390 416583 464497 468148 454804 567063 416676 500313 401810 401769 513830 516611 531839 771887 412855 469221 413392 416614 577038 612091 471117 471128 589408 785109 188560 401768 431439 416174 414595 414253 540868 480255 454590 467584 480258 534545 531834 529617 534563 536129 522639 530402 467636 475504 476053 574377 545459 561019 564271 660380 669062 672944 660369 672952 666854 671038 609920 586113 594143 600144 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (1.58%) |
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 182686 188560 385390 387749 390615 401768 401769 401810 412855 413392 414253 414595 416174 416583 416614 416676 431439 454368 454590 454804 464497 467584 467636 468148 469221 471117 471128 475504 476053 476658 480255 480258 500313 508759 513830 516611 522639 529617 530402 530688 531580 531834 531839 534545 534563 536129 540868 545453 545459 558455 561019 564271 566775 567063 568501 574377 577038 586113 589408 589526 594143 600144 602329 609920 612091 614957 616236 618259 634109 640081 640353 648704 652788 654978 658816 660369 660380 660394 666854 668305 669062 671002 671020 671038 672944 672952 677640 686830 693398 697108 705378 710434 738468 741684 749672 750145 751314 752592 752630 752669 756779 769364 771887 777752 782047 784701 785109 786904 789234 791871 792726 796685 800318 804000 806834 807170 807560 810870 814140 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер огромные дилд"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam huge dildo"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.80%) |
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.