Query Metrics
7
Database Queries
7
Different statements
365.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.06 ms (58.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade compilation"
]
|
||||||||||||||||||||||||||||||
|
129.38 ms (35.42%) |
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 391872 395378 422676 423963 435239 453972 456946 461636 474316 489260 501281 505291 522277 526887 554494 559729 561166 562819 569580 577919 580354 592009 605128 614695 615897 621289 629606 629653 635020 636501 643071 645076 668784 669672 674603 677120 678259 679607 680654 691479 697462 698779 699518 708052 708254 709340 710822 711672 714070 715610 716735 716946 717202 718685 718891 719038 719535 721910 727266 727980 730069 738888 741515 745347 747989 750275 755049 757089 757133 757134 757290 758715 760764 761345 761834 762339 770528 771644 771909 775163 775650 776194 777563 777939 778204 778741 778788 778814 778988 779077 779085 782377 782389 783928 785553 785625 789518 793474 793594 793613 793885 794435 794539 795024 795673 797228 797444 799438 801460 801634 801714 801993 804662 805261 807472 813984 816811 819728 819829 827330 ] |
||||||||||||||||||||||||||||||
|
15.81 ms (4.33%) |
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 745347 747989 762339 750275 757133 761345 771909 709340 715610 716946 718685 777939 778788 778814 779085 797228 391872 569580 645076 668784 699518 708254 677120 674603 678259 679607 710822 711672 714070 561166 629606 621289 635020 643071 605128 727266 758715 761834 614695 698779 489260 592009 827330 819829 395378 501281 526887 562819 718891 721910 669672 691479 708052 554494 779077 793613 741515 775163 776194 423963 435239 456946 505291 522277 559729 422676 816811 461636 819728 813984 680654 716735 697462 719535 577919 580354 615897 629653 636501 778988 782377 785553 795673 799438 801460 801634 805261 775650 785625 789518 795024 801714 804662 807472 783928 793594 794539 801993 730069 727980 770528 738888 755049 757290 760764 757089 757134 771644 717202 719038 777563 778204 778741 782389 793474 793885 794435 797444 474316 453972 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (0.67%) |
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 391872 395378 422676 423963 435239 453972 456946 461636 474316 489260 501281 505291 522277 526887 554494 559729 561166 562819 569580 577919 580354 592009 605128 614695 615897 621289 629606 629653 635020 636501 643071 645076 668784 669672 674603 677120 678259 679607 680654 691479 697462 698779 699518 708052 708254 709340 710822 711672 714070 715610 716735 716946 717202 718685 718891 719038 719535 721910 727266 727980 730069 738888 741515 745347 747989 750275 755049 757089 757133 757134 757290 758715 760764 761345 761834 762339 770528 771644 771909 775163 775650 776194 777563 777939 778204 778741 778788 778814 778988 779077 779085 782377 782389 783928 785553 785625 789518 793474 793594 793613 793885 794435 794539 795024 795673 797228 797444 799438 801460 801634 801714 801993 804662 805261 807472 813984 816811 819728 819829 827330 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск подборк"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.50%) |
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.