Query Metrics
7
Database Queries
7
Different statements
214.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.54 ms (87.10%) |
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 157194 384521 387601 388856 390761 397385 398909 401470 401531 401621 404664 404972 406210 408129 409021 409143 411841 412790 413895 416056 417811 418270 419220 422725 431314 444733 446002 446534 447516 447679 449358 460226 464246 468829 469513 472312 472788 473148 476981 478652 479851 479860 480400 483150 489871 497881 499821 499857 512818 514709 515433 516656 517745 518218 518504 519225 519726 522186 522881 530465 533060 533958 534218 535546 540262 553292 562829 562881 567743 568034 569919 571194 576622 576702 578478 586644 586917 591355 600351 625181 632289 637430 642659 650312 663254 665781 669341 670190 671654 672105 676127 676303 686035 691561 695919 717677 721025 721711 737522 756192 760653 761555 765478 769894 770897 775956 783145 786371 787289 789953 800509 801012 801475 802450 806789 815905 816886 818215 820052 821238 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (8.15%) |
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 431314 519726 518218 489871 512818 686035 672105 600351 637430 802450 765478 717677 390761 476981 447679 553292 472312 816886 821238 530465 406210 522186 800509 517745 578478 567743 669341 676303 625181 401621 412790 562881 737522 384521 447516 469513 586644 586917 473148 478652 416056 518504 533958 497881 514709 480400 515433 446534 571194 721025 801475 760653 721711 806789 387601 417811 483150 650312 691561 676127 789953 761555 783145 422725 815905 642659 769894 401531 404664 418270 404972 534218 770897 388856 460226 398909 449358 516656 522881 820052 818215 568034 695919 671654 786371 801012 670190 540262 533060 663254 775956 632289 787289 419220 468829 464246 569919 576622 665781 562829 576702 756192 409021 413895 446002 479860 479851 444733 519225 499857 157194 397385 535546 499821 591355 401470 408129 409143 411841 472788 ] |
||||||||||||||||||||||||||||||
|
3.80 ms (1.78%) |
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 157194 384521 387601 388856 390761 397385 398909 401470 401531 401621 404664 404972 406210 408129 409021 409143 411841 412790 413895 416056 417811 418270 419220 422725 431314 444733 446002 446534 447516 447679 449358 460226 464246 468829 469513 472312 472788 473148 476981 478652 479851 479860 480400 483150 489871 497881 499821 499857 512818 514709 515433 516656 517745 518218 518504 519225 519726 522186 522881 530465 533060 533958 534218 535546 540262 553292 562829 562881 567743 568034 569919 571194 576622 576702 578478 586644 586917 591355 600351 625181 632289 637430 642659 650312 663254 665781 669341 670190 671654 672105 676127 676303 686035 691561 695919 717677 721025 721711 737522 756192 760653 761555 765478 769894 770897 775956 783145 786371 787289 789953 800509 801012 801475 802450 806789 815905 816886 818215 820052 821238 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"красивые милфы аналь"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая милф анал"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.63%) |
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.