Query Metrics
7
Database Queries
7
Different statements
181.52 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.80 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.53 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleeping bed"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.54 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 586594 618718 415846 428970 439571 440614 439214 446811 423923 439742 439713 493181 492099 512843 515135 559913 504768 428451 452131 474473 514653 513189 521027 521807 529777 573765 564647 568007 606567 603759 600843 443737 422205 471046 489281 489516 536402 494779 513680 484653 588943 511242 580665 622408 470309 484581 521832 496100 471628 508441 519930 563884 565153 584739 619184 637404 603981 477052 594580 518450 541780 555893 565795 619107 591351 597491 617191 621273 420635 430444 520445 556002 607129 614603 617004 620098 621228 439819 515840 525287 567188 468897 550882 550662 682252 560230 585101 554784 538027 591235 ] |
||||||||||||||||||||||||||||||
| 4 | 2.52 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 415846 420635 422205 423923 428451 428970 430444 439214 439571 439713 439742 439819 440614 443737 446811 452131 468897 470309 471046 471628 474473 477052 484581 484653 489281 489516 492099 493181 494779 496100 504768 508441 511242 512843 513189 513680 514653 515135 515840 518450 519930 520445 521027 521807 521832 525287 529777 536402 538027 541780 550662 550882 554784 555893 556002 559913 560230 563884 564647 565153 565795 567188 568007 573765 580665 584739 585101 586594 588943 591235 591351 594580 597491 600843 603759 603981 606567 607129 614603 617004 617191 618718 619107 619184 620098 621228 621273 622408 637404 682252 ] |
||||||||||||||||||||||||||||||
| 5 | 154.29 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 415846 420635 422205 423923 428451 428970 430444 439214 439571 439713 439742 439819 440614 443737 446811 452131 468897 470309 471046 471628 474473 477052 484581 484653 489281 489516 492099 493181 494779 496100 504768 508441 511242 512843 513189 513680 514653 515135 515840 518450 519930 520445 521027 521807 521832 525287 529777 536402 538027 541780 550662 550882 554784 555893 556002 559913 560230 563884 564647 565153 565795 567188 568007 573765 580665 584739 585101 586594 588943 591235 591351 594580 597491 600843 603759 603981 606567 607129 614603 617004 617191 618718 619107 619184 620098 621228 621273 622408 637404 682252 ] |
||||||||||||||||||||||||||||||
| 6 | 1.90 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ постел"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.94 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.