Query Metrics
7
Database Queries
7
Different statements
126.81 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.97 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.93 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"поцелуи рук"
]
|
||||||||||||||||||||||||||||||
| 3 | 22.00 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 559119 566536 576095 543198 546347 550415 564646 570998 574546 581684 650806 659216 651938 652594 652610 656710 659579 562763 566538 582137 625395 598437 613055 618923 628277 636283 637049 593992 597542 598859 598870 603102 607087 620559 590221 593832 605445 614992 622824 602003 602761 608416 614920 413274 469424 521739 485265 484519 488596 508437 517092 534994 567347 574527 541721 556912 560651 567367 584708 654422 554272 598485 586576 623678 589642 621228 593125 596054 598080 446376 468446 426116 522403 524528 520697 529367 502741 528353 487926 526218 527990 534167 550434 561576 589127 603954 478672 529390 483355 ] |
||||||||||||||||||||||||||||||
| 4 | 3.49 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 413274 426116 446376 468446 469424 478672 483355 484519 485265 487926 488596 502741 508437 517092 520697 521739 522403 524528 526218 527990 528353 529367 529390 534167 534994 541721 543198 546347 550415 550434 554272 556912 559119 560651 561576 562763 564646 566536 566538 567347 567367 570998 574527 574546 576095 581684 582137 584708 586576 589127 589642 590221 593125 593832 593992 596054 597542 598080 598437 598485 598859 598870 602003 602761 603102 603954 605445 607087 608416 613055 614920 614992 618923 620559 621228 622824 623678 625395 628277 636283 637049 650806 651938 652594 652610 654422 656710 659216 659579 ] |
||||||||||||||||||||||||||||||
| 5 | 93.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 413274 426116 446376 468446 469424 478672 483355 484519 485265 487926 488596 502741 508437 517092 520697 521739 522403 524528 526218 527990 528353 529367 529390 534167 534994 541721 543198 546347 550415 550434 554272 556912 559119 560651 561576 562763 564646 566536 566538 567347 567367 570998 574527 574546 576095 581684 582137 584708 586576 589127 589642 590221 593125 593832 593992 596054 597542 598080 598437 598485 598859 598870 602003 602761 603102 603954 605445 607087 608416 613055 614920 614992 618923 620559 621228 622824 623678 625395 628277 636283 637049 650806 651938 652594 652610 654422 656710 659216 659579 ] |
||||||||||||||||||||||||||||||
| 6 | 1.92 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"поцел рук"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.63 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.