Query Metrics
7
Database Queries
7
Different statements
152.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.15 ms (85.51%) |
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 394747 395492 395682 395867 397072 399754 400157 401945 410413 414976 416841 418213 421346 421394 422754 425773 426094 426301 428966 428987 429471 429906 430742 445731 447142 449112 449579 456894 459226 467908 471899 473023 476120 476360 483978 484117 485303 489161 500699 504720 506469 511279 515734 519277 522148 524110 526132 537518 538870 540168 544479 544591 545312 545330 546690 549426 550101 550208 550214 552005 552912 552913 553452 556408 559118 559867 559868 561124 563876 564247 566761 567020 568738 571092 571124 571447 572621 572902 577767 578531 579922 580287 580301 585198 591556 591829 592396 593117 596415 598670 598783 601038 605332 606699 606749 608426 610365 618734 621029 622607 622991 623544 623569 636707 647605 662071 665936 680212 696443 715319 735128 797726 800396 802295 806422 812052 818825 819537 823181 827888 ] |
||||||||||||||||||||||||||||||
|
12.90 ms (8.47%) |
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 823181 827888 459226 445731 456894 545312 556408 563876 564247 696443 561124 571092 593117 622607 802295 735128 618734 421346 426094 471899 511279 504720 580301 549426 665936 598670 605332 621029 797726 428966 401945 410413 414976 394747 467908 568738 484117 421394 428987 566761 476120 397072 422754 449112 485303 522148 519277 545330 580287 550101 577767 622991 591556 800396 806422 500699 418213 399754 819537 540168 550208 552912 559118 559868 544479 546690 553452 544591 647605 550214 572621 608426 592396 596415 606749 606699 812052 473023 430742 524110 515734 483978 476360 395867 449579 426301 425773 572902 578531 662071 506469 395682 416841 680212 447142 559867 571124 591829 395492 429906 552005 571447 552913 598783 623569 400157 429471 818825 489161 537518 526132 538870 579922 567020 636707 585198 601038 610365 623544 715319 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.80%) |
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 394747 395492 395682 395867 397072 399754 400157 401945 410413 414976 416841 418213 421346 421394 422754 425773 426094 426301 428966 428987 429471 429906 430742 445731 447142 449112 449579 456894 459226 467908 471899 473023 476120 476360 483978 484117 485303 489161 500699 504720 506469 511279 515734 519277 522148 524110 526132 537518 538870 540168 544479 544591 545312 545330 546690 549426 550101 550208 550214 552005 552912 552913 553452 556408 559118 559867 559868 561124 563876 564247 566761 567020 568738 571092 571124 571447 572621 572902 577767 578531 579922 580287 580301 585198 591556 591829 592396 593117 596415 598670 598783 601038 605332 606699 606749 608426 610365 618734 621029 622607 622991 623544 623569 636707 647605 662071 665936 680212 696443 715319 735128 797726 800396 802295 806422 812052 818825 819537 823181 827888 ] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny hairy sex"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые волосатая секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые волосатая секс"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.95%) |
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.