Query Metrics
7
Database Queries
7
Different statements
160.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.93 ms (82.79%) |
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 402631 445245 455363 455391 457630 458960 460611 465252 468654 469666 469668 474768 482439 483766 483768 483779 483781 492567 498821 505300 507510 508257 509955 511328 512899 513977 514133 514662 518897 529878 534037 534860 550491 550553 558722 559290 561915 565880 573350 574667 582741 582744 584392 584420 585229 588142 591000 591535 594589 595147 599069 602179 605564 605635 605743 607519 607859 610241 618224 618752 619259 627336 635197 636708 636715 636718 636738 636739 643149 645795 648475 650911 651520 651664 667014 680030 688703 692818 693884 700010 703825 704121 704991 705026 705478 707524 710363 710466 710597 714795 715061 720655 727459 733337 734635 736544 743952 754487 755443 757983 759755 759917 763174 768839 770145 778492 782554 784102 784104 792721 792766 795032 795125 796327 796336 800987 804713 805225 807731 814402 ] |
||||||||||||||||||||||||||||||
|
16.92 ms (10.54%) |
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 534037 550553 645795 705026 651520 573350 636718 636708 636739 643149 591000 599069 607859 800987 755443 757983 768839 618224 792721 795032 483779 492567 465252 511328 508257 559290 402631 474768 458960 460611 469668 507510 509955 534860 498821 514662 561915 667014 688703 703825 704991 705478 710363 692818 700010 710597 605743 636738 784104 736544 759755 734635 715061 720655 792766 455363 483768 483781 513977 584420 574667 585229 482439 469666 584392 710466 591535 635197 636715 605564 627336 782554 727459 754487 714795 483766 582741 457630 514133 445245 512899 505300 565880 582744 648475 650911 680030 558722 595147 594589 619259 602179 778492 759917 804713 770145 743952 784102 795125 455391 518897 814402 468654 529878 550491 651664 707524 693884 588142 610241 607519 605635 796336 805225 733337 763174 618752 704121 796327 807731 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.73%) |
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 402631 445245 455363 455391 457630 458960 460611 465252 468654 469666 469668 474768 482439 483766 483768 483779 483781 492567 498821 505300 507510 508257 509955 511328 512899 513977 514133 514662 518897 529878 534037 534860 550491 550553 558722 559290 561915 565880 573350 574667 582741 582744 584392 584420 585229 588142 591000 591535 594589 595147 599069 602179 605564 605635 605743 607519 607859 610241 618224 618752 619259 627336 635197 636708 636715 636718 636738 636739 643149 645795 648475 650911 651520 651664 667014 680030 688703 692818 693884 700010 703825 704121 704991 705026 705478 707524 710363 710466 710597 714795 715061 720655 727459 733337 734635 736544 743952 754487 755443 757983 759755 759917 763174 768839 770145 778492 782554 784102 784104 792721 792766 795032 795125 796327 796336 800987 804713 805225 807731 814402 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam pregnant"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер беремен"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.04%) |
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.