Query Metrics
7
Database Queries
7
Different statements
150.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.83 ms (81.20%) |
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 383285 397680 459876 499578 511615 532517 543600 547099 552019 557270 559419 562406 583539 585283 599363 601619 608609 610953 615409 616645 617880 618411 622548 623918 633268 637311 644171 645557 649066 651977 653115 654453 674502 677191 680616 689983 692744 693511 695764 698256 700696 701180 705769 714372 715183 715489 718113 718648 725431 727283 728937 729036 731350 732162 733023 734561 735431 735481 736981 737458 738127 744607 745011 745610 746300 747997 748000 753281 753704 755760 759008 760440 761354 766307 768072 770373 771561 771935 772662 773390 778972 780160 783019 785246 785793 787647 788537 789547 791323 791644 793043 793521 793826 794109 794418 794438 794460 794490 794511 794724 794893 795646 795824 795828 796215 796309 796490 796767 797565 799894 800693 803936 804044 807245 810054 818445 819852 824253 827392 ] |
||||||||||||||||||||||||||||||
|
12.70 ms (8.47%) |
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 689983 547099 585283 616645 637311 617880 618411 633268 796309 778972 804044 725431 791323 810054 760440 733023 735431 747997 768072 771561 771935 773390 785793 789547 795646 680616 700696 793826 794490 796767 737458 794438 735481 738127 803936 397680 824253 827392 532517 543600 552019 714372 692744 705769 653115 698256 715183 718113 559419 562406 615409 622548 610953 795824 799894 785246 787647 791644 796215 800693 729036 745011 753281 753704 772662 770373 732162 755760 763812 746300 715489 780160 793043 795828 807245 459876 744607 728937 383285 818445 819852 511615 499578 649066 651977 677191 693511 645557 654453 674502 695764 701180 557270 583539 601619 608609 644171 599363 623918 794418 794511 797565 783019 794109 734561 794893 796490 748000 745610 759008 727283 731350 736981 761354 766307 718648 788537 793521 794460 794724 ] |
||||||||||||||||||||||||||||||
|
7.93 ms (5.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"inside of pussy"
]
|
||||||||||||||||||||||||||||||
|
2.72 ms (1.82%) |
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 383285 397680 459876 499578 511615 532517 543600 547099 552019 557270 559419 562406 583539 585283 599363 601619 608609 610953 615409 616645 617880 618411 622548 623918 633268 637311 644171 645557 649066 651977 653115 654453 674502 677191 680616 689983 692744 693511 695764 698256 700696 701180 705769 714372 715183 715489 718113 718648 725431 727283 728937 729036 731350 732162 733023 734561 735431 735481 736981 737458 738127 744607 745011 745610 746300 747997 748000 753281 753704 755760 759008 760440 761354 766307 768072 770373 771561 771935 772662 773390 778972 780160 783019 785246 785793 787647 788537 789547 791323 791644 793043 793521 793826 794109 794418 794438 794460 794490 794511 794724 794893 795646 795824 795828 796215 796309 796490 796767 797565 799894 800693 803936 804044 807245 810054 818445 819852 824253 827392 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"inside pussy"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"inside pussy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.04%) |
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.