Query Metrics
7
Database Queries
7
Different statements
179.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.44 ms (84.44%) |
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 4252 21323 388098 388805 390827 396374 397168 398212 401856 412015 413488 420130 420261 451013 451691 452391 453228 453461 455125 458716 463722 464616 465660 465945 472238 476094 479275 480230 481669 482656 482662 489994 491788 497669 504609 513188 515748 523024 527050 547312 548466 553298 554412 560887 562141 577076 578150 580033 581500 584430 594625 595696 603557 603702 604854 613903 616625 620047 620880 622199 624815 631684 638181 640148 664820 665192 665315 667879 669201 669452 671328 671745 675263 675923 675974 676388 693777 707529 709300 715451 715833 717621 734218 736020 738198 740131 749874 752604 753964 755214 755828 756914 759599 760039 760831 768412 773206 776722 778119 783485 790339 792563 793610 793844 797631 805295 805952 806181 807088 807387 808018 808086 808696 811335 814988 815365 815723 819297 822646 826980 ] |
||||||||||||||||||||||||||||||
|
17.20 ms (9.59%) |
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 527050 805295 595696 396374 756914 580033 523024 822646 675974 693777 715451 620880 640148 738198 755828 808696 760039 736020 709300 783485 826980 819297 752604 463722 453228 481669 482656 811335 455125 451013 707529 594625 604854 755214 753964 21323 413488 412015 453461 480230 548466 815723 815365 814988 675923 807387 603702 464616 624815 420130 497669 554412 667879 613903 616625 476094 491788 515748 578150 581500 622199 631684 749874 715833 390827 577076 717621 401856 665315 671745 664820 669201 792563 734218 776722 547312 805952 562141 808086 807088 472238 513188 740131 452391 458716 482662 504609 584430 671328 793844 603557 489994 4252 388805 388098 669452 620047 790339 808018 768412 793610 797631 420261 451691 465945 560887 676388 665192 553298 638181 806181 759599 760831 773206 778119 398212 479275 397168 465660 675263 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (2.17%) |
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 4252 21323 388098 388805 390827 396374 397168 398212 401856 412015 413488 420130 420261 451013 451691 452391 453228 453461 455125 458716 463722 464616 465660 465945 472238 476094 479275 480230 481669 482656 482662 489994 491788 497669 504609 513188 515748 523024 527050 547312 548466 553298 554412 560887 562141 577076 578150 580033 581500 584430 594625 595696 603557 603702 604854 613903 616625 620047 620880 622199 624815 631684 638181 640148 664820 665192 665315 667879 669201 669452 671328 671745 675263 675923 675974 676388 693777 707529 709300 715451 715833 717621 734218 736020 738198 740131 749874 752604 753964 755214 755828 756914 759599 760039 760831 768412 773206 776722 778119 783485 790339 792563 793610 793844 797631 805295 805952 806181 807088 807387 808018 808086 808696 811335 814988 815365 815723 819297 822646 826980 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big boobs sex"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие boobs секс"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие boobs секс"
]
|
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.