Query Metrics
7
Database Queries
7
Different statements
156.62 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.79 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.10 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мама сильно"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.99 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 808077 554776 602610 569960 536903 606600 499867 538333 507124 550615 511345 603709 599353 577435 615975 563446 605111 552706 557776 556121 592921 605255 805983 554790 609225 573759 619407 574450 527442 553269 567220 605953 597736 593162 477873 663347 522210 645270 601176 468517 543434 578631 513148 527199 684305 598654 529355 506606 474818 564224 550641 622778 407252 504411 564203 465336 493204 452228 587152 621764 488904 569955 608930 614611 605764 601125 609248 523253 623678 521810 553949 559922 475630 590514 527908 491823 493958 565783 486904 608230 528712 582468 524544 545643 607129 404584 523336 621559 554392 616779 ] |
||||||||||||||||||||||||||||||
| 4 | 2.35 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 404584 407252 452228 465336 468517 474818 475630 477873 486904 488904 491823 493204 493958 499867 504411 506606 507124 511345 513148 521810 522210 523253 523336 524544 527199 527442 527908 528712 529355 536903 538333 543434 545643 550615 550641 552706 553269 553949 554392 554776 554790 556121 557776 559922 563446 564203 564224 565783 567220 569955 569960 573759 574450 577435 578631 582468 587152 590514 592921 593162 597736 598654 599353 601125 601176 602610 603709 605111 605255 605764 605953 606600 607129 608230 608930 609225 609248 614611 615975 616779 619407 621559 621764 622778 623678 645270 663347 684305 805983 808077 ] |
||||||||||||||||||||||||||||||
| 5 | 127.30 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 404584 407252 452228 465336 468517 474818 475630 477873 486904 488904 491823 493204 493958 499867 504411 506606 507124 511345 513148 521810 522210 523253 523336 524544 527199 527442 527908 528712 529355 536903 538333 543434 545643 550615 550641 552706 553269 553949 554392 554776 554790 556121 557776 559922 563446 564203 564224 565783 567220 569955 569960 573759 574450 577435 578631 582468 587152 590514 592921 593162 597736 598654 599353 601125 601176 602610 603709 605111 605255 605764 605953 606600 607129 608230 608930 609225 609248 614611 615975 616779 619407 621559 621764 622778 623678 645270 663347 684305 805983 808077 ] |
||||||||||||||||||||||||||||||
| 6 | 1.58 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин сильн"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.50 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.