Query Metrics
7
Database Queries
7
Different statements
410.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.06 ms (50.18%) |
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 154844 383606 397197 398101 401810 413006 414124 449916 457216 471091 471126 471130 471163 471168 477507 487291 494529 494532 497471 497830 505137 505143 510746 514085 514848 531347 531580 531822 537269 539470 539639 542163 545449 545462 547458 547479 547502 550892 550897 550917 565036 567122 568498 573257 574038 575171 577038 584119 587292 588694 589836 595622 596252 599477 600922 600938 602885 604105 619710 621496 621562 625785 625797 627194 634108 634109 644335 648960 650246 656856 659967 662049 663234 663317 666855 671520 684500 701238 705119 705571 705641 720101 721257 723361 730060 738476 739123 744038 745083 745201 745292 745931 745933 752675 752686 752755 754628 756771 757494 759324 760548 760594 760596 768508 769148 772257 777751 777768 782108 782517 783261 784236 788027 791880 792697 792730 794307 805046 ] |
||||||||||||||||||||||||||||||
|
185.03 ms (45.06%) |
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 154844 383606 397197 398101 401810 413006 414124 449916 457216 471091 471126 471130 471163 471168 477507 487291 494529 494532 497471 497830 505137 505143 510746 514085 514848 531347 531580 531822 537269 539470 539639 542163 545449 545462 547458 547479 547502 550892 550897 550917 565036 567122 568498 573257 574038 575171 577038 584119 587292 588694 589836 595622 596252 599477 600922 600938 602885 604105 619710 621496 621562 625785 625797 627194 634108 634109 644335 648960 650246 656856 659967 662049 663234 663317 666855 671520 684500 701238 705119 705571 705641 720101 721257 723361 730060 738476 739123 744038 745083 745201 745292 745931 745933 752675 752686 752755 754628 756771 757494 759324 760548 760594 760596 768508 769148 772257 777751 777768 782108 782517 783261 784236 788027 791880 792697 792730 794307 805046 ] |
||||||||||||||||||||||||||||||
|
13.04 ms (3.18%) |
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 663234 644335 745201 756771 760594 621496 588694 599477 471163 457216 477507 505143 656856 471130 745292 584119 730060 768508 783261 471126 574038 744038 595622 701238 413006 497471 545449 575171 547479 659967 666855 671520 720101 550917 794307 777751 777768 792730 772257 510746 545462 550892 663317 550897 760548 757494 745931 604105 792697 154844 539639 539470 568498 547502 600938 788027 401810 383606 648960 650246 602885 621562 625797 625785 745933 589836 573257 634109 577038 721257 739123 766362 759324 531822 547458 542163 662049 705119 705641 567122 600922 782517 752675 738476 752686 752755 769148 745083 588152 565036 596252 537269 494532 684500 619710 627194 784236 782108 760596 705571 791880 494529 805046 471168 531580 723361 754628 397197 398101 449916 497830 514085 505137 514848 471091 414124 487291 531347 634108 587292 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"home made dildo"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск дилд"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск дилд"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.