Query Metrics
7
Database Queries
7
Different statements
385.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.22 ms (53.50%) |
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 129902 190870 346979 348262 383719 387026 388973 391521 419777 420886 430876 449872 452006 452594 453456 454196 455034 455175 455910 460032 461060 465654 466150 472310 476086 476158 476771 479145 485089 485365 486986 490905 490927 491996 499816 501205 501505 506002 512046 512344 512494 513214 515588 515602 515617 515679 517952 519438 526222 532983 542193 544260 544794 546712 546928 549528 550686 552021 555170 563168 567321 568483 569918 578155 586655 587155 588631 590492 592413 595446 600851 600858 604307 605221 605990 607202 607269 612403 617680 643188 646447 647611 666353 666830 667523 667694 693331 704068 716879 720473 721773 727653 728295 734611 742695 745461 752950 760818 790951 796243 801416 804530 804825 805354 810734 811220 812912 814140 814332 814760 815063 815138 815152 815290 815413 815799 815956 816085 820173 823644 ] |
||||||||||||||||||||||||||||||
|
153.32 ms (39.78%) |
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 129902 190870 346979 348262 383719 387026 388973 391521 419777 420886 430876 449872 452006 452594 453456 454196 455034 455175 455910 460032 461060 465654 466150 472310 476086 476158 476771 479145 485089 485365 486986 490905 490927 491996 499816 501205 501505 506002 512046 512344 512494 513214 515588 515602 515617 515679 517952 519438 526222 532983 542193 544260 544794 546712 546928 549528 550686 552021 555170 563168 567321 568483 569918 578155 586655 587155 588631 590492 592413 595446 600851 600858 604307 605221 605990 607202 607269 612403 617680 643188 646447 647611 666353 666830 667523 667694 693331 704068 716879 720473 721773 727653 728295 734611 742695 745461 752950 760818 790951 796243 801416 804530 804825 805354 810734 811220 812912 814140 814332 814760 815063 815138 815152 815290 815413 815799 815956 816085 820173 823644 ] |
||||||||||||||||||||||||||||||
|
18.43 ms (4.78%) |
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 452594 465654 383719 348262 454196 466150 512494 515679 519438 526222 515588 513214 666353 600851 592413 455034 479145 430876 491996 567321 388973 816085 815799 815956 815152 823644 814332 815138 460032 512046 544794 563168 555170 568483 667523 667694 647611 666830 587155 595446 600858 605990 643188 604307 607269 790951 805354 727653 752950 796243 801416 804530 804825 812912 728295 734611 745461 760818 742695 612403 617680 716879 810734 476086 485365 485089 490905 815290 472310 578155 546712 811220 449872 391521 387026 452006 501205 501505 512344 517952 486986 490927 515617 542193 455910 515602 544260 499816 453456 590492 607202 820173 814760 815063 815413 532983 461060 549528 646447 588631 419777 420886 129902 190870 346979 814140 476771 476158 455175 506002 569918 546928 693331 704068 720473 721773 550686 552021 605221 586655 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"office stockings"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секретарш чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.40%) |
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.