Query Metrics
7
Database Queries
7
Different statements
342.57 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.75 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.94 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom two"
]
|
||||||||||||||||||||||||||||||
| 3 | 17.66 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 511568 533697 473900 547485 583503 542746 542794 543234 563844 649240 681310 719336 581816 598911 590281 585446 591607 593534 600275 639706 596882 634487 634782 792576 813244 750064 803659 801471 391400 527232 518493 528098 533610 526470 522606 531235 565423 576689 669058 603295 633786 597787 619405 604473 608031 641690 411189 409861 478832 511812 495700 506211 486706 511193 522212 444924 814901 482496 514580 551225 559577 670951 682531 470074 535013 526373 577435 584488 607413 629963 617422 450998 519198 576726 639258 590884 484870 464139 614074 476907 485313 521136 562108 643316 445617 543848 ] |
||||||||||||||||||||||||||||||
| 4 | 3.56 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 391400 409861 411189 444924 445617 450998 464139 470074 473900 476907 478832 482496 484870 485313 486706 495700 506211 511193 511568 511812 514580 518493 519198 521136 522212 522606 526373 526470 527232 528098 531235 533610 533697 535013 542746 542794 543234 543848 547485 551225 559577 562108 563844 565423 576689 576726 577435 581816 583503 584488 585446 590281 590884 591607 593534 596882 597787 598911 600275 603295 604473 607413 608031 614074 617422 619405 629963 633786 634487 634782 639258 639706 641690 643316 649240 669058 670951 681310 682531 719336 750064 792576 801471 803659 813244 814901 ] |
||||||||||||||||||||||||||||||
| 5 | 104.23 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 391400 409861 411189 444924 445617 450998 464139 470074 473900 476907 478832 482496 484870 485313 486706 495700 506211 511193 511568 511812 514580 518493 519198 521136 522212 522606 526373 526470 527232 528098 531235 533610 533697 535013 542746 542794 543234 543848 547485 551225 559577 562108 563844 565423 576689 576726 577435 581816 583503 584488 585446 590281 590884 591607 593534 596882 597787 598911 600275 603295 604473 607413 608031 614074 617422 619405 629963 633786 634487 634782 639258 639706 641690 643316 649240 669058 670951 681310 682531 719336 750064 792576 801471 803659 813244 814901 ] |
||||||||||||||||||||||||||||||
| 6 | 211.77 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom two"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.65 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom two"
]
|
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.