Query Metrics
7
Database Queries
7
Different statements
429.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.82 ms (49.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen pantyhose 18"
]
|
||||||||||||||||||||||||||||||
|
190.12 ms (44.25%) |
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 365871 389979 391246 396408 396994 419029 429819 447335 462914 470090 470137 497471 510071 517204 527531 529015 537393 544083 547400 552482 556911 561186 584164 584485 599350 609291 612832 613503 617778 619187 619668 625292 626930 630234 632573 633300 634512 653270 660340 661495 661652 669347 669961 671814 674216 682227 682642 697427 698513 703973 707895 710686 712698 715940 716890 717553 723566 724091 724373 728996 735107 739141 740454 740578 740861 741187 741901 741952 742463 743109 744852 745087 747324 747481 747956 748339 748965 750198 755937 757635 758906 760688 760963 761575 764208 767289 767798 768949 769865 769977 771353 771601 772635 772783 775484 777033 777731 780526 782625 785591 787513 787887 788661 790245 790415 790554 792139 793673 793957 799995 800496 805203 806641 809018 810125 810450 815243 824920 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (3.80%) |
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 470090 661652 698513 703973 633300 609291 612832 775484 790415 792139 793957 777033 780526 788661 809018 810450 771353 758906 740578 760688 761575 767798 772635 617778 777731 517204 778213 769977 740454 697427 806641 613503 419029 669961 470137 462914 630234 785591 741187 510071 497471 632573 626930 747956 764208 740861 787887 790245 723566 824920 584485 707895 715940 717553 710686 599350 619668 793673 787513 790554 724091 724373 767289 768949 769865 757635 742463 772783 716890 365871 447335 552482 527531 760963 744852 391246 653270 669347 747324 396994 429819 815243 529015 671814 682227 728996 747481 634512 547400 674216 743109 748339 755937 741901 771601 750198 389979 396408 556911 537393 544083 584164 661495 712698 660340 682642 561186 619187 625292 799995 800496 805203 782625 766050 810125 739141 741952 735107 745087 748965 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (0.75%) |
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 365871 389979 391246 396408 396994 419029 429819 447335 462914 470090 470137 497471 510071 517204 527531 529015 537393 544083 547400 552482 556911 561186 584164 584485 599350 609291 612832 613503 617778 619187 619668 625292 626930 630234 632573 633300 634512 653270 660340 661495 661652 669347 669961 671814 674216 682227 682642 697427 698513 703973 707895 710686 712698 715940 716890 717553 723566 724091 724373 728996 735107 739141 740454 740578 740861 741187 741901 741952 742463 743109 744852 745087 747324 747481 747956 748339 748965 750198 755937 757635 758906 760688 760963 761575 764208 767289 767798 768949 769865 769977 771353 771601 772635 772783 775484 777033 777731 780526 782625 785591 787513 787887 788661 790245 790415 790554 792139 793673 793957 799995 800496 805203 806641 809018 810125 810450 815243 824920 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen pantyhose 18"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen pantyhose 18"
]
|
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.