Query Metrics
7
Database Queries
7
Different statements
168.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.11 ms (86.59%) |
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 396905 397283 413739 417154 421762 431593 442842 463398 463399 464267 475392 485826 501591 510900 513511 518022 533363 538619 544826 549080 584469 586165 590087 599115 600415 610140 616505 616526 631059 632077 636308 637430 637554 646525 647080 674603 684404 693680 697933 698918 699671 702246 707307 711416 715378 716014 722794 724240 724498 725020 725082 726925 726978 727578 728205 728907 729157 730093 733120 733567 734436 734706 734851 734959 734969 736330 738332 738356 738803 738809 739403 739521 741553 742102 742592 742657 742916 743083 743356 745227 747822 747982 748126 748620 749760 750292 750463 751220 755172 756354 756681 756910 756979 757038 757751 760630 760888 761679 766799 767917 779264 779534 784397 786156 786816 786863 790196 792717 806098 806176 807705 809425 810942 817755 817863 817990 820380 823265 ] |
||||||||||||||||||||||||||||||
|
13.60 ms (8.06%) |
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 760888 766799 784397 786816 786863 807705 725020 725082 728205 734706 738809 741553 743083 750463 761679 726925 726978 729157 734436 734851 738332 738803 745227 756979 767917 730093 736330 739521 742916 747982 748126 750292 751220 755172 760630 724240 727578 728907 734959 734969 738356 742102 742592 743356 749760 756354 756910 757038 610140 631059 632077 697933 699671 711416 722794 786156 787389 792717 806098 809425 549080 636308 600415 817755 817990 823265 510900 501591 475392 584469 544826 646525 698918 715378 647080 637430 810942 757751 742657 739403 637554 702246 707307 779264 790196 442842 716014 724498 616505 733567 693680 590087 756681 431593 826156 464267 733120 806176 533363 674603 684404 586165 616526 748620 747822 599115 779534 397283 396905 413739 417154 421762 817863 820380 463398 463399 485826 513511 518022 538619 ] |
||||||||||||||||||||||||||||||
|
2.58 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 396905 397283 413739 417154 421762 431593 442842 463398 463399 464267 475392 485826 501591 510900 513511 518022 533363 538619 544826 549080 584469 586165 590087 599115 600415 610140 616505 616526 631059 632077 636308 637430 637554 646525 647080 674603 684404 693680 697933 698918 699671 702246 707307 711416 715378 716014 722794 724240 724498 725020 725082 726925 726978 727578 728205 728907 729157 730093 733120 733567 734436 734706 734851 734959 734969 736330 738332 738356 738803 738809 739403 739521 741553 742102 742592 742657 742916 743083 743356 745227 747822 747982 748126 748620 749760 750292 750463 751220 755172 756354 756681 756910 756979 757038 757751 760630 760888 761679 766799 767917 779264 779534 784397 786156 786816 786863 790196 792717 806098 806176 807705 809425 810942 817755 817863 817990 820380 823265 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock creampie"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock creampie"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock creampie"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.85%) |
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.