Query Metrics
7
Database Queries
7
Different statements
163.68 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.46 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.90 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"моется"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.18 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 557052 603970 615721 592184 597576 618869 636643 466921 473866 420227 433017 461788 444138 459476 509430 517599 522779 487547 488100 512244 522249 523711 489381 505069 534662 398655 453297 457562 466730 520194 505232 555986 571828 561954 665107 690300 585229 593029 425631 442997 474992 422188 457832 475258 454202 467388 521025 484640 497676 510425 511557 511127 526006 487758 519721 538001 453469 579707 417511 482256 470287 483628 436932 566243 564643 608686 603407 465948 440548 446267 525890 489346 520911 550705 558337 578703 564563 482270 528452 503272 543479 658952 663888 681215 457502 520232 541770 502512 ] |
||||||||||||||||||||||||||||||
| 4 | 2.61 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 398655 417511 420227 422188 425631 433017 436932 440548 442997 444138 446267 453297 453469 454202 457502 457562 457832 459476 461788 465948 466730 466921 467388 470287 473866 474992 475258 482256 482270 483628 484640 487547 487758 488100 489346 489381 497676 502512 503272 505069 505232 509430 510425 511127 511557 512244 517599 519721 520194 520232 520911 521025 522249 522779 523711 525890 526006 528452 534662 538001 541770 543479 550705 555986 557052 558337 561954 564563 564643 566243 571828 578703 579707 585229 592184 593029 597576 603407 603970 608686 615721 618869 636643 658952 663888 665107 681215 690300 ] |
||||||||||||||||||||||||||||||
| 5 | 140.02 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 398655 417511 420227 422188 425631 433017 436932 440548 442997 444138 446267 453297 453469 454202 457502 457562 457832 459476 461788 465948 466730 466921 467388 470287 473866 474992 475258 482256 482270 483628 484640 487547 487758 488100 489346 489381 497676 502512 503272 505069 505232 509430 510425 511127 511557 512244 517599 519721 520194 520232 520911 521025 522249 522779 523711 525890 526006 528452 534662 538001 541770 543479 550705 555986 557052 558337 561954 564563 564643 566243 571828 578703 579707 585229 592184 593029 597576 603407 603970 608686 615721 618869 636643 658952 663888 665107 681215 690300 ] |
||||||||||||||||||||||||||||||
| 6 | 1.80 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"моет"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.70 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.