Query Metrics
7
Database Queries
7
Different statements
164.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.68 ms (82.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 338371 386166 391717 393670 397785 406339 421482 421971 425594 432543 433435 433574 433600 433618 433662 433867 445431 451161 452322 452394 458605 462969 466987 469177 469644 470170 470422 470961 471693 475032 505979 508750 510010 511761 515720 516035 523390 524115 525081 525965 527497 528361 529018 529022 535427 542002 547658 550480 560925 571219 571834 574887 597003 599072 601194 614967 616296 621259 624689 632697 633472 633518 634106 635141 636059 636183 637106 637134 644498 651611 656942 659315 687431 689315 689616 694010 694953 702627 710946 711274 715050 716900 720273 721549 728167 735768 740934 747469 752566 755630 758201 758579 761495 761625 764116 766835 772449 775269 776484 777173 777921 781006 784744 785606 785868 787438 792799 796364 797247 800572 804319 805242 806043 806842 806919 808787 811786 816755 819613 821044 ] |
||||||||||||||||||||||||||||||
|
17.19 ms (10.48%) |
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 735768 747469 761625 635141 715050 777173 777921 784744 800572 393670 421482 433600 433867 516035 525081 510010 515720 547658 560925 525965 466987 637134 632697 386166 338371 819613 821044 816755 462969 469644 470422 445431 451161 475032 505979 523390 508750 529018 535427 542002 550480 574887 656942 651611 659315 689616 694010 694953 711274 687431 689315 710946 720273 721549 571219 634106 636183 599072 624689 636059 597003 614967 616296 601194 637106 781006 804319 805242 806919 808787 811786 776484 787438 796364 806842 740934 758579 761495 772449 785606 785868 792799 797247 806043 755630 766835 752566 758201 764116 728167 633472 633518 644498 702627 775269 391717 452322 458605 470961 421971 433435 433662 397785 406339 425594 432543 469177 470170 433574 433618 452394 471693 511761 529022 524115 527497 716900 528361 571834 621259 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (2.08%) |
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 338371 386166 391717 393670 397785 406339 421482 421971 425594 432543 433435 433574 433600 433618 433662 433867 445431 451161 452322 452394 458605 462969 466987 469177 469644 470170 470422 470961 471693 475032 505979 508750 510010 511761 515720 516035 523390 524115 525081 525965 527497 528361 529018 529022 535427 542002 547658 550480 560925 571219 571834 574887 597003 599072 601194 614967 616296 621259 624689 632697 633472 633518 634106 635141 636059 636183 637106 637134 644498 651611 656942 659315 687431 689315 689616 694010 694953 702627 710946 711274 715050 716900 720273 721549 728167 735768 740934 747469 752566 755630 758201 758579 761495 761625 764116 766835 772449 775269 776484 777173 777921 781006 784744 785606 785868 787438 792799 796364 797247 800572 804319 805242 806043 806842 806919 808787 811786 816755 819613 821044 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen tights"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen колготк"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen колготк"
]
|
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.