Query Metrics
7
Database Queries
7
Different statements
161.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.17 ms (83.30%) |
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 82281 382725 391934 396570 401228 404117 419765 419868 421215 432131 445728 445733 449194 455211 455847 456737 456849 458183 461551 467573 467632 471886 477185 478527 479217 481672 482125 487146 489603 496528 500493 500552 502106 506786 508848 511162 511171 511748 512665 512966 522840 524404 524698 530867 533192 533261 542059 542080 542082 545785 546002 548297 554538 556319 558275 560474 562208 563508 563659 564465 565936 567335 574793 574830 575070 575087 575150 575470 576041 576377 581305 582291 585740 588835 594885 599219 604581 605527 605654 606691 611754 611924 611980 615100 620125 620797 622844 633832 649608 653755 655359 655671 656466 656470 657066 659810 663359 663414 678959 686776 692209 694203 704852 710965 715083 723675 728424 732553 733223 742165 742174 745759 748781 779069 781656 789656 813511 815851 820333 824541 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (10.14%) |
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 813511 546002 604581 404117 421215 419765 467573 479217 481672 502106 496528 563659 567335 575150 575470 562208 565936 574793 576041 732553 391934 455847 482125 456737 419868 455211 512665 512966 487146 511748 489603 508848 524698 733223 458183 824541 820333 449194 456849 530867 500552 556319 575070 655359 659810 692209 649608 655671 657066 678959 710965 656466 663359 663414 686776 558275 594885 599219 605527 611754 611924 779069 728424 742165 745759 742174 605654 611980 620125 382725 471886 542082 545785 467632 478527 432131 815851 548297 576377 620797 585740 82281 522840 524404 533192 533261 554538 564465 582291 542080 560474 574830 581305 653755 704852 694203 656470 563508 615100 633832 606691 588835 622844 781656 748781 723675 715083 789656 396570 461551 506786 401228 445728 445733 477185 511162 500493 511171 575087 542059 ] |
||||||||||||||||||||||||||||||
|
3.67 ms (2.28%) |
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 82281 382725 391934 396570 401228 404117 419765 419868 421215 432131 445728 445733 449194 455211 455847 456737 456849 458183 461551 467573 467632 471886 477185 478527 479217 481672 482125 487146 489603 496528 500493 500552 502106 506786 508848 511162 511171 511748 512665 512966 522840 524404 524698 530867 533192 533261 542059 542080 542082 545785 546002 548297 554538 556319 558275 560474 562208 563508 563659 564465 565936 567335 574793 574830 575070 575087 575150 575470 576041 576377 581305 582291 585740 588835 594885 599219 604581 605527 605654 606691 611754 611924 611980 615100 620125 620797 622844 633832 649608 653755 655359 655671 656466 656470 657066 659810 663359 663414 678959 686776 692209 694203 704852 710965 715083 723675 728424 732553 733223 742165 742174 745759 748781 779069 781656 789656 813511 815851 820333 824541 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.00%) |
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.