Query Metrics
7
Database Queries
7
Different statements
203.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.96 ms (85.83%) |
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 89895 95986 341622 349135 387648 391930 394597 398567 413905 414301 416720 416742 417830 420358 421077 423500 423572 423647 426592 428404 429909 431385 433232 441500 441789 443773 445455 445538 446030 446257 447661 448817 448825 449061 451670 451866 452612 452637 452798 453948 456372 456813 457341 458017 460209 463798 465153 466884 468355 468665 469520 471663 473446 473461 474557 474778 478090 478110 478597 480457 483814 484809 486476 486854 490685 491270 494231 495786 496090 496340 496729 497275 500100 500938 510061 510132 512224 512608 513965 516590 519316 520216 526162 526366 533855 535621 541764 542692 542993 543918 547658 551748 552623 555391 569147 579580 580123 581997 592541 637002 641660 651601 652939 654165 680271 696594 706118 769400 780784 784219 786463 786876 788576 788608 790219 792557 799762 806060 824263 826182 ] |
||||||||||||||||||||||||||||||
|
18.51 ms (9.08%) |
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 423647 474778 526162 542692 341622 473446 652939 89895 451670 446030 466884 551748 443773 426592 535621 542993 429909 637002 394597 441789 520216 581997 465153 452798 510132 452637 468665 478110 458017 387648 391930 500100 478597 441500 543918 547658 469520 448825 580123 491270 784219 447661 500938 496340 451866 95986 786876 446257 579580 452612 533855 792557 423572 706118 480457 641660 788608 790219 421077 428404 680271 541764 512224 445455 769400 456813 457341 651601 513965 494231 826182 420358 526366 592541 416720 460209 456372 431385 463798 516590 519316 654165 569147 417830 349135 496729 497275 433232 510061 495786 448817 414301 453948 423500 788576 696594 799762 486854 398567 552623 490685 449061 824263 806060 780784 471663 478090 468355 483814 413905 474557 484809 445538 786463 486476 416742 555391 473461 496090 512608 ] |
||||||||||||||||||||||||||||||
|
3.76 ms (1.85%) |
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 89895 95986 341622 349135 387648 391930 394597 398567 413905 414301 416720 416742 417830 420358 421077 423500 423572 423647 426592 428404 429909 431385 433232 441500 441789 443773 445455 445538 446030 446257 447661 448817 448825 449061 451670 451866 452612 452637 452798 453948 456372 456813 457341 458017 460209 463798 465153 466884 468355 468665 469520 471663 473446 473461 474557 474778 478090 478110 478597 480457 483814 484809 486476 486854 490685 491270 494231 495786 496090 496340 496729 497275 500100 500938 510061 510132 512224 512608 513965 516590 519316 520216 526162 526366 533855 535621 541764 542692 542993 543918 547658 551748 552623 555391 569147 579580 580123 581997 592541 637002 641660 651601 652939 654165 680271 696594 706118 769400 780784 784219 786463 786876 788576 788608 790219 792557 799762 806060 824263 826182 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal gape compilation"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал большая большие дырк подборк"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.28 ms (0.63%) |
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.