Query Metrics
7
Database Queries
7
Different statements
197.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
165.29 ms (83.73%) |
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 209373 361993 395143 396372 396744 408974 421172 423708 426131 431105 431805 435066 436178 437526 440990 443761 443772 445473 446589 447454 451552 451559 452762 454251 455912 456384 462315 463245 464327 465060 466094 466097 466321 467963 470596 471723 472793 474013 474024 474827 476409 477707 479866 483162 483487 484463 484656 484665 484666 484693 484696 485700 485703 485735 486182 490838 491294 492839 495703 495741 497534 497579 497865 497917 500363 501248 501251 501254 502147 504165 505622 506047 507675 510742 511764 512058 514733 515179 516029 519208 520753 521438 523683 527884 528760 528808 532676 545718 546682 548730 551050 551245 552009 554134 557676 557985 560446 562826 565351 575800 576052 576116 579351 587817 591680 595756 597739 599888 603803 622044 622248 622253 622255 640136 647328 650633 660424 671863 730798 748236 ] |
||||||||||||||||||||||||||||||
|
20.19 ms (10.23%) |
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 640136 595756 440990 474827 484665 516029 485700 501248 510742 396372 423708 445473 492839 527884 528760 552009 548730 551050 560446 575800 576116 622044 587817 748236 408974 431805 209373 471723 446589 361993 396744 421172 447454 443761 443772 451559 505622 490838 497579 491294 515179 511764 528808 501251 532676 484693 477707 485735 502147 603803 599888 462315 456384 466094 466097 466321 484666 484656 495703 495741 504165 557985 557676 730798 485703 484696 484463 562826 501254 650633 476409 395143 426131 437526 463245 545718 546682 554134 576052 579351 647328 660424 551245 465060 474013 454251 479866 451552 483162 514733 523683 497534 472793 435066 500363 597739 622248 622253 474024 455912 497865 512058 671863 436178 506047 521438 591680 520753 565351 622255 464327 470596 497917 431105 452762 467963 507675 486182 519208 483487 ] |
||||||||||||||||||||||||||||||
|
4.42 ms (2.24%) |
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 209373 361993 395143 396372 396744 408974 421172 423708 426131 431105 431805 435066 436178 437526 440990 443761 443772 445473 446589 447454 451552 451559 452762 454251 455912 456384 462315 463245 464327 465060 466094 466097 466321 467963 470596 471723 472793 474013 474024 474827 476409 477707 479866 483162 483487 484463 484656 484665 484666 484693 484696 485700 485703 485735 486182 490838 491294 492839 495703 495741 497534 497579 497865 497917 500363 501248 501251 501254 502147 504165 505622 506047 507675 510742 511764 512058 514733 515179 516029 519208 520753 521438 523683 527884 528760 528808 532676 545718 546682 548730 551050 551245 552009 554134 557676 557985 560446 562826 565351 575800 576052 576116 579351 587817 591680 595756 597739 599888 603803 622044 622248 622253 622255 640136 647328 650633 660424 671863 730798 748236 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade group"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск group"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск group"
]
|
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.