Query Metrics
7
Database Queries
7
Different statements
170.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.28 ms (81.63%) |
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 447944 450886 519218 538945 538949 539503 541725 541822 542488 542500 544276 544278 546716 546957 550040 551681 554321 554900 556988 559064 560075 560081 560390 561005 562830 562846 562976 563123 563142 563200 563210 563220 563435 563538 566686 566699 570859 571239 574263 576662 576697 581359 581401 585088 589659 590421 590932 592392 592492 595386 598348 603225 605336 615726 615743 615749 618071 619464 619466 621692 621976 623155 624470 629936 633095 634692 644323 644381 644382 645254 646942 648206 649621 649989 650833 652562 662397 664410 665651 668465 670106 670947 671764 672158 672734 677703 677712 681031 681182 690833 692030 692209 692481 692805 693032 694056 694072 694206 694488 697359 697459 697976 698431 699723 700741 703522 704525 708785 716323 722103 732585 733299 746794 751017 754424 770146 800422 811940 819506 823358 ] |
||||||||||||||||||||||||||||||
|
20.43 ms (11.97%) |
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 652562 672734 692481 649621 664410 692030 697976 698431 708785 551681 618071 623155 605336 732585 754424 733299 746794 633095 644382 703522 722103 562976 563123 668465 681182 554900 595386 560390 554321 563200 563142 694072 563435 590421 624470 751017 541725 560081 585088 819506 538949 560075 562830 576697 546716 546957 559064 561005 562846 566686 544278 563220 566699 571239 671764 672158 681031 694056 670947 677712 697459 704525 716323 650833 677703 592492 621692 592392 598348 615743 615749 619464 619466 621976 800422 823358 539503 563538 542488 544276 563210 581359 648206 649989 662397 690833 692209 694206 694488 665651 670106 692805 693032 697359 699723 645254 646942 550040 556988 570859 574263 589659 644381 590932 603225 629936 811940 770146 634692 644323 700741 519218 541822 447944 615726 581401 450886 538945 542500 576662 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин vintage"
]
|
||||||||||||||||||||||||||||||
|
2.47 ms (1.45%) |
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 447944 450886 519218 538945 538949 539503 541725 541822 542488 542500 544276 544278 546716 546957 550040 551681 554321 554900 556988 559064 560075 560081 560390 561005 562830 562846 562976 563123 563142 563200 563210 563220 563435 563538 566686 566699 570859 571239 574263 576662 576697 581359 581401 585088 589659 590421 590932 592392 592492 595386 598348 603225 605336 615726 615743 615749 618071 619464 619466 621692 621976 623155 624470 629936 633095 634692 644323 644381 644382 645254 646942 648206 649621 649989 650833 652562 662397 664410 665651 668465 670106 670947 671764 672158 672734 677703 677712 681031 681182 690833 692030 692209 692481 692805 693032 694056 694072 694206 694488 697359 697459 697976 698431 699723 700741 703522 704525 708785 716323 722103 732585 733299 746794 751017 754424 770146 800422 811940 819506 823358 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother vintage"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.92%) |
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.