Query Metrics
7
Database Queries
7
Different statements
164.74 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.53 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.43 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"american xxx"
]
|
||||||||||||||||||||||||||||||
| 3 | 11.99 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 542825 542855 543036 576532 692658 664376 678627 689673 646936 607638 629141 792636 382676 401047 407589 499818 495715 529361 458831 522397 522399 535012 517538 527999 542597 543117 574983 583200 560038 671334 577074 578028 605945 643011 590944 607509 643084 799565 633540 704221 809357 263335 418648 510358 525962 529468 443171 456613 454663 522395 536868 534999 545814 565924 566308 592974 459130 464634 484795 522405 425321 469182 466481 530500 522380 531489 576722 542861 808865 461211 420525 512071 534774 481789 543440 561140 428451 527598 449362 560190 519727 522414 543508 602610 617422 566079 603047 ] |
||||||||||||||||||||||||||||||
| 4 | 2.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 263335 382676 401047 407589 418648 420525 425321 428451 443171 449362 454663 456613 458831 459130 461211 464634 466481 469182 481789 484795 495715 499818 510358 512071 517538 519727 522380 522395 522397 522399 522405 522414 525962 527598 527999 529361 529468 530500 531489 534774 534999 535012 536868 542597 542825 542855 542861 543036 543117 543440 543508 545814 560038 560190 561140 565924 566079 566308 574983 576532 576722 577074 578028 583200 590944 592974 602610 603047 605945 607509 607638 617422 629141 633540 643011 643084 646936 664376 671334 678627 689673 692658 704221 792636 799565 808865 809357 ] |
||||||||||||||||||||||||||||||
| 5 | 143.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 263335 382676 401047 407589 418648 420525 425321 428451 443171 449362 454663 456613 458831 459130 461211 464634 466481 469182 481789 484795 495715 499818 510358 512071 517538 519727 522380 522395 522397 522399 522405 522414 525962 527598 527999 529361 529468 530500 531489 534774 534999 535012 536868 542597 542825 542855 542861 543036 543117 543440 543508 545814 560038 560190 561140 565924 566079 566308 574983 576532 576722 577074 578028 583200 590944 592974 602610 603047 605945 607509 607638 617422 629141 633540 643011 643084 646936 664376 671334 678627 689673 692658 704221 792636 799565 808865 809357 ] |
||||||||||||||||||||||||||||||
| 6 | 1.88 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"american xxx"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.69 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"american xxx"
]
|
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.