Query Metrics
7
Database Queries
7
Different statements
184.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.24 ms (86.74%) |
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 524951 538862 540668 542487 544270 544276 544287 544312 544482 544577 545403 547840 550189 550321 556777 556986 557895 563452 566830 567995 568030 573215 581119 581357 581363 587973 590575 592543 603200 606417 618902 620125 621691 621715 622020 622980 624469 624958 625757 628297 629409 633095 636265 645895 647308 648912 649557 649621 649989 650829 651902 652536 652562 653376 654130 661900 665751 668441 668590 668604 670373 671704 671708 671732 671856 671925 673531 690860 690872 691148 691499 691521 692023 692214 692224 692478 693032 693862 693985 694135 694137 694143 695204 695921 696358 697798 698396 698490 698513 698579 700275 703040 703521 705915 711894 719132 720398 720488 722103 725176 725518 727392 727740 727803 730225 730524 735931 741018 743851 745993 746794 748423 752728 759270 780605 780609 789399 793966 811940 817278 ] |
||||||||||||||||||||||||||||||
|
14.48 ms (7.84%) |
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 540668 654130 661900 700275 691499 647308 671856 692023 550189 668604 573215 581363 698490 720398 563452 618902 727392 730225 730524 625757 538862 567995 542487 544312 544482 544270 547840 668590 652536 695204 695921 711894 651902 691521 692214 693985 698396 556986 587973 621715 624958 590575 780605 743851 725518 735931 745993 748423 780609 524951 557895 628297 636265 671708 690872 690860 811940 620125 694143 633095 653376 629409 544287 648912 649621 752728 722103 545403 668441 703521 581119 650829 741018 817278 692224 568030 649557 691148 673531 697798 592543 624469 622020 789399 759270 727740 746794 727803 703040 694135 556777 671925 665751 606417 603200 621691 566830 544276 645895 649989 693862 705915 693032 670373 692478 544577 550321 671704 694137 719132 652562 696358 698513 698579 671732 720488 622980 793966 725176 581357 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.51%) |
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 524951 538862 540668 542487 544270 544276 544287 544312 544482 544577 545403 547840 550189 550321 556777 556986 557895 563452 566830 567995 568030 573215 581119 581357 581363 587973 590575 592543 603200 606417 618902 620125 621691 621715 622020 622980 624469 624958 625757 628297 629409 633095 636265 645895 647308 648912 649557 649621 649989 650829 651902 652536 652562 653376 654130 661900 665751 668441 668590 668604 670373 671704 671708 671732 671856 671925 673531 690860 690872 691148 691499 691521 692023 692214 692224 692478 693032 693862 693985 694135 694137 694143 695204 695921 696358 697798 698396 698490 698513 698579 700275 703040 703521 705915 711894 719132 720398 720488 722103 725176 725518 727392 727740 727803 730225 730524 735931 741018 743851 745993 746794 748423 752728 759270 780605 780609 789399 793966 811940 817278 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс vintage"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob vintage"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс vintage"
]
|
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.