Query Metrics
7
Database Queries
7
Different statements
120.11 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.91 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.29 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"раком худая брюнетка"
]
|
||||||||||||||||||||||||||||||
| 3 | 20.07 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 619165 601114 585630 604295 422949 397369 456627 473807 470344 517086 517190 574700 609842 624131 439819 528435 552331 557947 586628 623678 623834 536400 601094 622778 443112 418837 550097 657051 566330 578587 579881 580353 588499 591341 586629 805874 602747 404754 416233 489315 514815 558191 422960 413044 449580 475439 542516 654617 656686 590669 601363 590908 603888 461744 417177 613215 623337 593597 543832 564453 621975 596608 431446 431749 445416 563852 572771 554790 567354 656782 625183 590910 603488 604158 612698 589721 420635 500699 522543 560511 603813 596586 603906 567416 590878 ] |
||||||||||||||||||||||||||||||
| 4 | 2.96 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 397369 404754 413044 416233 417177 418837 420635 422949 422960 431446 431749 439819 443112 445416 449580 456627 461744 470344 473807 475439 489315 500699 514815 517086 517190 522543 528435 536400 542516 543832 550097 552331 554790 557947 558191 560511 563852 564453 566330 567354 567416 572771 574700 578587 579881 580353 585630 586628 586629 588499 589721 590669 590878 590908 590910 591341 593597 596586 596608 601094 601114 601363 602747 603488 603813 603888 603906 604158 604295 609842 612698 613215 619165 621975 622778 623337 623678 623834 624131 625183 654617 656686 656782 657051 805874 ] |
||||||||||||||||||||||||||||||
| 5 | 89.26 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 397369 404754 413044 416233 417177 418837 420635 422949 422960 431446 431749 439819 443112 445416 449580 456627 461744 470344 473807 475439 489315 500699 514815 517086 517190 522543 528435 536400 542516 543832 550097 552331 554790 557947 558191 560511 563852 564453 566330 567354 567416 572771 574700 578587 579881 580353 585630 586628 586629 588499 589721 590669 590878 590908 590910 591341 593597 596586 596608 601094 601114 601363 602747 603488 603813 603888 603906 604158 604295 609842 612698 613215 619165 621975 622778 623337 623678 623834 624131 625183 654617 656686 656782 657051 805874 ] |
||||||||||||||||||||||||||||||
| 6 | 1.88 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак худая черноволосая"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.72 ms |
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.