Query Metrics
7
Database Queries
7
Different statements
179.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.30 ms (82.73%) |
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 183074 290366 321277 384491 404738 411081 414070 414081 415957 416230 416511 416523 416525 416529 416581 416583 416600 416620 416624 416635 416684 416724 418069 418385 418817 421369 422803 425398 428241 432173 432928 433002 439249 444527 446543 448641 452809 452817 452937 453170 453213 454793 455901 456684 457071 460765 463832 466779 466860 467557 467568 467585 467598 467623 467939 468153 468186 468514 469845 471077 471105 471122 472190 476176 476649 479694 483315 484241 489075 491777 493788 494490 496564 496703 499365 499829 499836 499957 500736 502529 511413 513569 514927 515413 516718 517928 518191 520797 522459 525204 525355 527920 527922 528572 529047 542989 547767 547800 555144 556850 564643 567860 572245 573332 574381 577373 579264 584421 597590 598548 598940 601695 601766 603310 605858 632415 633485 642331 662444 710161 ] |
||||||||||||||||||||||||||||||
|
20.31 ms (11.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 574381 642331 605858 632415 416724 416523 525355 484241 489075 502529 528572 491777 499836 422803 446543 467585 472190 572245 567860 598940 633485 432173 471122 453213 525204 483315 493788 384491 404738 452809 453170 529047 499829 469845 577373 579264 597590 448641 416620 496703 518191 414070 499365 496564 321277 411081 433002 416525 467568 467598 468514 471105 527922 527920 515413 466860 547800 603310 476176 463832 457071 499957 500736 511413 564643 452817 466779 444527 455901 290366 416230 432928 454793 471077 573332 601766 601695 418817 439249 183074 418069 415957 416635 425398 468153 542989 547767 584421 710161 414081 421369 467557 494490 418385 467939 476649 513569 516718 416624 416583 416684 428241 460765 555144 556850 479694 416511 416581 416600 468186 522459 514927 520797 662444 416529 467623 598548 452937 456684 517928 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.53%) |
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 183074 290366 321277 384491 404738 411081 414070 414081 415957 416230 416511 416523 416525 416529 416581 416583 416600 416620 416624 416635 416684 416724 418069 418385 418817 421369 422803 425398 428241 432173 432928 433002 439249 444527 446543 448641 452809 452817 452937 453170 453213 454793 455901 456684 457071 460765 463832 466779 466860 467557 467568 467585 467598 467623 467939 468153 468186 468514 469845 471077 471105 471122 472190 476176 476649 479694 483315 484241 489075 491777 493788 494490 496564 496703 499365 499829 499836 499957 500736 502529 511413 513569 514927 515413 516718 517928 518191 520797 522459 525204 525355 527920 527922 528572 529047 542989 547767 547800 555144 556850 564643 567860 572245 573332 574381 577373 579264 584421 597590 598548 598940 601695 601766 603310 605858 632415 633485 642331 662444 710161 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde ass solo"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая жоп соло"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.91%) |
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.