Query Metrics
7
Database Queries
7
Different statements
148.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.07 ms (83.96%) |
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 4306 17037 31975 130126 150322 282652 322284 385984 390881 395990 398914 402024 410299 412749 413356 416737 419370 424617 459229 479190 485649 487429 505758 531655 534193 545990 546417 547381 548973 552390 554827 557462 558082 560301 560643 560952 565440 566846 566873 581194 581250 584265 585827 587452 593223 593826 594229 602034 604215 633552 639111 641714 642394 643513 645342 646244 648538 657224 657467 659396 662015 662146 663176 675607 680233 684501 686399 688939 690973 691662 692117 694347 694583 705225 713022 716998 718240 720688 720703 728735 731096 731890 743044 744090 746492 747377 747595 748415 749256 750126 752717 753449 753470 758576 761768 765097 765104 766337 767044 769744 769878 770379 778935 780135 781051 781334 782039 784622 786869 787936 788435 790496 799815 800584 803556 805996 813635 814250 823851 ] |
||||||||||||||||||||||||||||||
|
16.10 ms (10.81%) |
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 748415 769744 602034 782039 398914 769878 753449 766337 485649 150322 646244 585827 17037 604215 744090 750126 720688 419370 560301 402024 410299 813635 531655 548973 558082 557462 545990 554827 641714 587452 758576 765097 765104 770379 749256 731890 747377 781051 385984 560643 459229 778935 390881 663176 130126 282652 4306 412749 416737 657467 659396 552390 594229 479190 780135 705225 662146 684501 686399 593826 639111 633552 642394 643513 784622 788435 781334 747595 761768 786869 731096 746492 728735 767044 823851 743044 787936 413356 547381 593223 800584 805996 799815 753470 752717 791816 803556 487429 560952 505758 534193 566873 790496 424617 322284 395990 31975 814250 546417 565440 581194 581250 566846 584265 662015 675607 688939 690973 713022 718240 720703 657224 691662 692117 694347 716998 645342 648538 680233 694583 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.35%) |
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 4306 17037 31975 130126 150322 282652 322284 385984 390881 395990 398914 402024 410299 412749 413356 416737 419370 424617 459229 479190 485649 487429 505758 531655 534193 545990 546417 547381 548973 552390 554827 557462 558082 560301 560643 560952 565440 566846 566873 581194 581250 584265 585827 587452 593223 593826 594229 602034 604215 633552 639111 641714 642394 643513 645342 646244 648538 657224 657467 659396 662015 662146 663176 675607 680233 684501 686399 688939 690973 691662 692117 694347 694583 705225 713022 716998 718240 720688 720703 728735 731096 731890 743044 744090 746492 747377 747595 748415 749256 750126 752717 753449 753470 758576 761768 765097 765104 766337 767044 769744 769878 770379 778935 780135 781051 781334 782039 784622 786869 787936 788435 790496 799815 800584 803556 805996 813635 814250 823851 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал молодой девушки"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал молодой девушк"
]
|
||||||||||||||||||||||||||||||
|
1.18 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.