Query Metrics
7
Database Queries
7
Different statements
161.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.43 ms (80.82%) |
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 69876 147128 378600 391707 400713 400732 402021 411096 418544 420314 420548 435245 438495 448255 448300 454030 457272 461762 466458 486371 489626 491634 496510 504488 508800 511420 512961 518977 522277 524139 526683 559729 559817 561166 565563 583569 592009 593181 600575 603615 604264 604637 605128 607277 613240 615315 636557 660340 662062 667169 668784 675839 682373 686759 687330 689156 691166 693013 698779 701628 707629 708254 709764 710329 710877 714070 718472 718685 719038 724797 727256 727266 731062 732586 738114 738812 740231 742065 744091 745981 747987 752498 752785 755049 757134 757803 758300 760764 761345 761404 762339 771644 772353 772827 772944 777046 777563 777639 778204 778804 778834 783893 784409 785625 787995 788578 789518 793311 793594 793853 794539 795989 799438 800975 801300 801993 803448 804662 807464 807846 ] |
||||||||||||||||||||||||||||||
|
19.28 ms (11.95%) |
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 799438 785625 787995 789518 804662 793594 794539 801993 732586 755049 760764 761404 742065 757134 771644 719038 777563 778204 778834 691166 583569 709764 778804 454030 461762 526683 682373 718472 600575 777639 783893 793311 752498 772827 772944 724797 731062 740231 772353 758300 636557 710329 486371 660340 800975 592009 710877 662062 511420 508800 777046 793853 757803 738114 801300 701628 604264 604637 613240 435245 69876 803448 400732 418544 593181 400713 466458 565563 752785 744091 747987 788578 378600 391707 727256 687330 559817 795989 491634 615315 668784 708254 714070 561166 605128 727266 698779 667169 762339 761345 718685 147128 411096 707629 675839 784409 522277 559729 603615 738812 807464 689156 420548 504488 693013 745981 438495 457272 420314 807846 448255 402021 496510 686759 512961 607277 448300 524139 518977 489626 ] |
||||||||||||||||||||||||||||||
|
3.83 ms (2.38%) |
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 69876 147128 378600 391707 400713 400732 402021 411096 418544 420314 420548 435245 438495 448255 448300 454030 457272 461762 466458 486371 489626 491634 496510 504488 508800 511420 512961 518977 522277 524139 526683 559729 559817 561166 565563 583569 592009 593181 600575 603615 604264 604637 605128 607277 613240 615315 636557 660340 662062 667169 668784 675839 682373 686759 687330 689156 691166 693013 698779 701628 707629 708254 709764 710329 710877 714070 718472 718685 719038 724797 727256 727266 731062 732586 738114 738812 740231 742065 744091 745981 747987 752498 752785 755049 757134 757803 758300 760764 761345 761404 762339 771644 772353 772827 772944 777046 777563 777639 778204 778804 778834 783893 784409 785625 787995 788578 789518 793311 793594 793853 794539 795989 799438 800975 801300 801993 803448 804662 807464 807846 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation amateur sex"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.14%) |
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.