Query Metrics
7
Database Queries
7
Different statements
125.40 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.94 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.04 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx xxx x"
]
|
||||||||||||||||||||||||||||||
| 3 | 14.56 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 480433 483708 418991 410811 461120 470332 453934 468085 529380 534755 507912 552463 559658 548558 563796 575730 588838 457957 454066 400697 402632 420031 466006 468824 484822 491512 495367 507899 507219 405955 427251 420060 429366 470392 528832 525372 552627 548559 582377 688232 577398 594106 739077 373884 399141 480832 13913 504546 507887 519299 399140 472189 447318 449809 535374 540543 500348 542786 784158 402835 451064 514797 522568 420416 449372 582220 545730 574897 669577 593470 442168 500369 518382 523111 495608 475830 500364 536214 786120 474745 520771 625167 581117 541688 548490 ] |
||||||||||||||||||||||||||||||
| 4 | 2.93 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 13913 373884 399140 399141 400697 402632 402835 405955 410811 418991 420031 420060 420416 427251 429366 442168 447318 449372 449809 451064 453934 454066 457957 461120 466006 468085 468824 470332 470392 472189 474745 475830 480433 480832 483708 484822 491512 495367 495608 500348 500364 500369 504546 507219 507887 507899 507912 514797 518382 519299 520771 522568 523111 525372 528832 529380 534755 535374 536214 540543 541688 542786 545730 548490 548558 548559 552463 552627 559658 563796 574897 575730 577398 581117 582220 582377 588838 593470 594106 625167 669577 688232 739077 784158 786120 ] |
||||||||||||||||||||||||||||||
| 5 | 100.28 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 13913 373884 399140 399141 400697 402632 402835 405955 410811 418991 420031 420060 420416 427251 429366 442168 447318 449372 449809 451064 453934 454066 457957 461120 466006 468085 468824 470332 470392 472189 474745 475830 480433 480832 483708 484822 491512 495367 495608 500348 500364 500369 504546 507219 507887 507899 507912 514797 518382 519299 520771 522568 523111 525372 528832 529380 534755 535374 536214 540543 541688 542786 545730 548490 548558 548559 552463 552627 559658 563796 574897 575730 577398 581117 582220 582377 588838 593470 594106 625167 669577 688232 739077 784158 786120 ] |
||||||||||||||||||||||||||||||
| 6 | 2.01 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx xxx x"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.65 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx xxx x"
]
|
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.