Query Metrics
7
Database Queries
7
Different statements
178.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.59 ms (86.41%) |
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 132836 386548 395456 400096 407487 408830 415875 418464 418754 418856 419280 422017 422064 428847 438672 443329 446405 448585 448903 449112 454906 455315 455450 455929 460118 461077 470740 472355 473331 473611 474889 481036 485818 489156 491648 493242 500700 500745 509863 510391 520167 521196 521878 522842 527507 527526 531588 533464 538231 538401 538510 544880 551382 552151 552696 553092 553775 553776 558231 558360 558655 559474 560181 561069 570248 570276 570526 570528 570530 571555 572137 572151 572364 573430 573648 573667 573685 573720 573866 574532 576017 577382 579204 580735 587091 588615 589218 590830 593076 593999 594108 595077 596997 598599 599766 602662 603459 608091 609649 618432 620967 622068 623960 624078 626212 639960 648360 650731 650765 671077 685892 702509 706465 746935 748634 765448 778514 786458 795120 807967 ] |
||||||||||||||||||||||||||||||
|
14.48 ms (8.09%) |
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 570526 572151 573430 573667 573720 573866 559474 560181 570248 570528 570530 577382 551382 552151 552696 558360 561069 570276 572364 553092 558231 571555 572137 573648 573685 574532 576017 580735 599766 602662 626212 588615 603459 593076 596997 400096 419280 438672 448585 448903 455315 395456 407487 422064 443329 470740 408830 418464 428847 455450 473331 418754 418856 454906 461077 473611 481036 455929 460118 472355 474889 510391 509863 520167 521196 538231 491648 500700 521878 538401 538510 522842 493242 598599 622068 807967 765448 748634 609649 446405 531588 558655 671077 608091 590830 623960 786458 795120 746935 702509 386548 132836 422017 415875 485818 449112 489156 500745 527507 527526 533464 579204 553776 650731 706465 648360 650765 685892 544880 553775 593999 594108 624078 587091 639960 620967 589218 595077 618432 778514 ] |
||||||||||||||||||||||||||||||
|
2.62 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 132836 386548 395456 400096 407487 408830 415875 418464 418754 418856 419280 422017 422064 428847 438672 443329 446405 448585 448903 449112 454906 455315 455450 455929 460118 461077 470740 472355 473331 473611 474889 481036 485818 489156 491648 493242 500700 500745 509863 510391 520167 521196 521878 522842 527507 527526 531588 533464 538231 538401 538510 544880 551382 552151 552696 553092 553775 553776 558231 558360 558655 559474 560181 561069 570248 570276 570526 570528 570530 571555 572137 572151 572364 573430 573648 573667 573685 573720 573866 574532 576017 577382 579204 580735 587091 588615 589218 590830 593076 593999 594108 595077 596997 598599 599766 602662 603459 608091 609649 618432 620967 622068 623960 624078 626212 639960 648360 650731 650765 671077 685892 702509 706465 746935 748634 765448 778514 786458 795120 807967 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18-летние красотки"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 19 лет красивая"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 19 лет красивая"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.