Query Metrics
7
Database Queries
7
Different statements
201.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.05 ms (86.78%) |
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 4229 123002 394686 403404 405520 408773 409200 414987 415900 416037 420490 420534 428300 430696 442064 443218 444020 446023 446865 453086 453417 455981 456498 457300 459637 469500 482195 482197 491219 503964 507041 512167 516056 530183 534258 534688 546842 555180 558174 560885 565694 565730 565732 565749 565754 565771 572854 574425 574432 580221 580521 580897 582603 584395 585518 588331 597635 601204 612469 614346 622733 639019 645581 647636 653378 662405 664972 695173 712248 726465 726468 726480 726483 726484 726496 726507 726529 726530 726531 726542 726552 726561 726635 726691 726701 726702 726876 726911 727022 728483 729233 730986 733142 733451 733498 742779 742811 742860 742862 746827 748398 749379 750773 761496 764238 766619 769291 769509 769531 771179 780430 781767 784817 808654 809265 814399 824174 825951 826130 826248 ] |
||||||||||||||||||||||||||||||
|
17.54 ms (8.69%) |
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 771179 726465 726468 726484 726496 726530 726531 726542 726552 726561 726635 726702 726876 726911 733451 742862 764238 769291 769531 726529 726691 728483 730986 733142 742779 742860 746827 750773 761496 726480 726483 726507 726701 727022 729233 733498 742811 748398 749379 766619 769509 622733 780430 781767 784817 808654 809265 4229 408773 428300 453086 123002 403404 482197 409200 414987 416037 444020 443218 482195 446023 442064 825951 394686 405520 420490 420534 415900 430696 826130 826248 814399 824174 455981 456498 459637 469500 446865 453417 491219 457300 512167 530183 503964 507041 516056 534258 534688 546842 558174 565732 565754 572854 560885 574425 580897 582603 584395 555180 565694 565749 580221 647636 653378 695173 645581 662405 664972 712248 565730 565771 574432 580521 585518 588331 601204 639019 597635 612469 614346 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.47%) |
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 4229 123002 394686 403404 405520 408773 409200 414987 415900 416037 420490 420534 428300 430696 442064 443218 444020 446023 446865 453086 453417 455981 456498 457300 459637 469500 482195 482197 491219 503964 507041 512167 516056 530183 534258 534688 546842 555180 558174 560885 565694 565730 565732 565749 565754 565771 572854 574425 574432 580221 580521 580897 582603 584395 585518 588331 597635 601204 612469 614346 622733 639019 645581 647636 653378 662405 664972 695173 712248 726465 726468 726480 726483 726484 726496 726507 726529 726530 726531 726542 726552 726561 726635 726691 726701 726702 726876 726911 727022 728483 729233 730986 733142 733451 733498 742779 742811 742860 742862 746827 748398 749379 750773 761496 764238 766619 769291 769509 769531 771179 780430 781767 784817 808654 809265 814399 824174 825951 826130 826248 ] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby latina"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby латинская"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby латинская"
]
|
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.