Query Metrics
7
Database Queries
7
Different statements
158.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.82 ms (82.77%) |
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 28242 233135 365992 366478 391563 401594 401858 402226 404121 404257 409728 411368 420513 423520 426336 427091 428929 432304 432794 444841 445720 447538 447555 455322 460351 466417 467306 470978 473091 473240 474272 479694 480004 480306 482031 482075 482221 482403 485575 489118 489573 489609 491185 491326 491457 491938 492841 492994 493271 496453 496725 503636 505031 506287 507665 508546 508873 508876 509083 509663 513313 513472 513710 516740 523970 525942 527167 527629 534040 538207 539126 552430 555834 558205 560630 561632 561829 565953 581967 586601 586603 595401 595497 595515 596459 596600 596630 596649 597048 597066 598508 598544 598773 600159 603103 626880 637002 652869 652927 675798 683242 701486 712380 720850 722814 742224 742846 747709 750753 754584 761147 766248 782602 786372 788905 790531 790925 799714 812346 827221 ] |
||||||||||||||||||||||||||||||
|
18.24 ms (11.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 460351 466417 420513 508873 509083 527167 558205 505031 595515 401858 28242 799714 766248 428929 404257 411368 473240 482221 538207 552430 626880 786372 742846 561829 586601 423520 503636 506287 491457 508546 827221 683242 652927 790531 747709 754584 401594 365992 482403 597048 586603 467306 479694 455322 474272 480004 473091 447555 485575 513472 492994 496453 489573 509663 523970 534040 600159 742224 427091 233135 409728 491185 366478 581967 565953 596649 597066 596630 426336 480306 447538 527629 491326 491938 513313 750753 712380 720850 598508 790925 761147 722814 516740 561632 560630 782602 788905 444841 482075 470978 508876 489118 489609 493271 496725 525942 539126 603103 432794 701486 652869 513710 555834 596459 596600 482031 492841 507665 404121 432304 402226 595401 637002 675798 595497 598544 391563 812346 598773 445720 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.69%) |
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 28242 233135 365992 366478 391563 401594 401858 402226 404121 404257 409728 411368 420513 423520 426336 427091 428929 432304 432794 444841 445720 447538 447555 455322 460351 466417 467306 470978 473091 473240 474272 479694 480004 480306 482031 482075 482221 482403 485575 489118 489573 489609 491185 491326 491457 491938 492841 492994 493271 496453 496725 503636 505031 506287 507665 508546 508873 508876 509083 509663 513313 513472 513710 516740 523970 525942 527167 527629 534040 538207 539126 552430 555834 558205 560630 561632 561829 565953 581967 586601 586603 595401 595497 595515 596459 596600 596630 596649 597048 597066 598508 598544 598773 600159 603103 626880 637002 652869 652927 675798 683242 701486 712380 720850 722814 742224 742846 747709 750753 754584 761147 766248 782602 786372 788905 790531 790925 799714 812346 827221 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русский анал с красоткой"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск анал красивая"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.90%) |
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.