Query Metrics
7
Database Queries
7
Different statements
127.72 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.03 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.01 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"husband wife friend"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.23 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 584180 542536 668969 492690 500506 732733 641901 478525 470391 435642 489299 496935 514659 551532 551553 560368 519851 514661 511897 513408 439566 440901 517372 514264 579541 591413 614565 517465 545009 426710 504909 487472 545216 559793 564644 564656 587918 498205 610786 458183 517595 536684 567067 440974 521077 515645 522768 659391 603640 520448 462904 543536 494857 623306 456448 519261 591416 720257 585332 518636 599533 494036 467580 449387 586554 593860 395970 396253 430548 502541 561135 578631 482506 587855 523212 509713 608206 606948 591415 628426 622778 513126 523537 524417 618326 ] |
||||||||||||||||||||||||||||||
| 4 | 3.13 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 395970 396253 426710 430548 435642 439566 440901 440974 449387 456448 458183 462904 467580 470391 478525 482506 487472 489299 492690 494036 494857 496935 498205 500506 502541 504909 509713 511897 513126 513408 514264 514659 514661 515645 517372 517465 517595 518636 519261 519851 520448 521077 522768 523212 523537 524417 536684 542536 543536 545009 545216 551532 551553 559793 560368 561135 564644 564656 567067 578631 579541 584180 585332 586554 587855 587918 591413 591415 591416 593860 599533 603640 606948 608206 610786 614565 618326 622778 623306 628426 641901 659391 668969 720257 732733 ] |
||||||||||||||||||||||||||||||
| 5 | 102.72 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 395970 396253 426710 430548 435642 439566 440901 440974 449387 456448 458183 462904 467580 470391 478525 482506 487472 489299 492690 494036 494857 496935 498205 500506 502541 504909 509713 511897 513126 513408 514264 514659 514661 515645 517372 517465 517595 518636 519261 519851 520448 521077 522768 523212 523537 524417 536684 542536 543536 545009 545216 551532 551553 559793 560368 561135 564644 564656 567067 578631 579541 584180 585332 586554 587855 587918 591413 591415 591416 593860 599533 603640 606948 608206 610786 614565 618326 622778 623306 628426 641901 659391 668969 720257 732733 ] |
||||||||||||||||||||||||||||||
| 6 | 1.94 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"husband жен friend"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.66 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"husband жен friend"
]
|
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.