Query Metrics
7
Database Queries
7
Different statements
143.11 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.80 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.16 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc teen latina"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.86 ms |
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 606599 623962 521523 579329 530382 634198 811826 676090 537686 623203 70082 404459 492134 534650 649504 720245 597142 623292 641702 633773 401842 488551 454802 666538 672159 628082 522138 644962 820779 539239 500913 532741 526188 536631 539424 509454 649579 564740 596196 604295 604460 633444 433040 452139 417344 495608 594280 457165 530499 537672 537675 537903 537659 464168 545441 561980 543917 674952 645993 629951 628091 632639 518394 585139 536638 537660 530060 517788 568589 589484 592034 633775 414666 583507 648560 649546 674967 642706 634801 531123 545389 588265 445641 536703 475479 628333 496033 598105 ] |
||||||||||||||||||||||||||||||
| 4 | 2.30 ms |
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 70082 401842 404459 414666 417344 433040 445641 452139 454802 457165 464168 475479 488551 492134 495608 496033 500913 509454 517788 518394 521523 522138 526188 530060 530382 530499 531123 532741 534650 536631 536638 536703 537659 537660 537672 537675 537686 537903 539239 539424 543917 545389 545441 561980 564740 568589 579329 583507 585139 588265 589484 592034 594280 596196 597142 598105 604295 604460 606599 623203 623292 623962 628082 628091 628333 629951 632639 633444 633773 633775 634198 634801 641702 642706 644962 645993 648560 649504 649546 649579 666538 672159 674952 674967 676090 720245 811826 820779 ] |
||||||||||||||||||||||||||||||
| 5 | 117.86 ms |
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 70082 401842 404459 414666 417344 433040 445641 452139 454802 457165 464168 475479 488551 492134 495608 496033 500913 509454 517788 518394 521523 522138 526188 530060 530382 530499 531123 532741 534650 536631 536638 536703 537659 537660 537672 537675 537686 537903 539239 539424 543917 545389 545441 561980 564740 568589 579329 583507 585139 588265 589484 592034 594280 596196 597142 598105 604295 604460 606599 623203 623292 623962 628082 628091 628333 629951 632639 633444 633773 633775 634198 634801 641702 642706 644962 645993 648560 649504 649546 649579 666538 672159 674952 674967 676090 720245 811826 820779 ] |
||||||||||||||||||||||||||||||
| 6 | 1.72 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc teen латинская"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.39 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc teen латинская"
]
|
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.