Query Metrics
7
Database Queries
7
Different statements
162.75 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.91 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.17 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blacked blacked"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.11 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 423708 423339 482793 448864 466340 460799 604595 636593 732574 396746 399388 445514 463262 402092 471723 395406 395446 391541 398154 399355 399414 416069 445321 464146 500431 488623 485110 498594 527452 387766 390024 437526 419854 429729 435624 421557 446344 463073 562110 563992 562128 573304 582012 569457 636564 605557 630915 604417 635490 429424 445513 420345 417390 517849 528831 510270 413944 417889 532779 530789 414621 396742 480439 495734 518493 399263 468655 528101 532343 506143 557526 614621 586651 460706 434001 417482 399300 418363 399717 495752 525864 603258 620203 580280 518438 609922 604478 605521 562108 ] |
||||||||||||||||||||||||||||||
| 4 | 3.42 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 387766 390024 391541 395406 395446 396742 396746 398154 399263 399300 399355 399388 399414 399717 402092 413944 414621 416069 417390 417482 417889 418363 419854 420345 421557 423339 423708 429424 429729 434001 435624 437526 445321 445513 445514 446344 448864 460706 460799 463073 463262 464146 466340 468655 471723 480439 482793 485110 488623 495734 495752 498594 500431 506143 510270 517849 518438 518493 525864 527452 528101 528831 530789 532343 532779 557526 562108 562110 562128 563992 569457 573304 580280 582012 586651 603258 604417 604478 604595 605521 605557 609922 614621 620203 630915 635490 636564 636593 732574 ] |
||||||||||||||||||||||||||||||
| 5 | 135.99 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 387766 390024 391541 395406 395446 396742 396746 398154 399263 399300 399355 399388 399414 399717 402092 413944 414621 416069 417390 417482 417889 418363 419854 420345 421557 423339 423708 429424 429729 434001 435624 437526 445321 445513 445514 446344 448864 460706 460799 463073 463262 464146 466340 468655 471723 480439 482793 485110 488623 495734 495752 498594 500431 506143 510270 517849 518438 518493 525864 527452 528101 528831 530789 532343 532779 557526 562108 562110 562128 563992 569457 573304 580280 582012 586651 603258 604417 604478 604595 605521 605557 609922 614621 620203 630915 635490 636564 636593 732574 ] |
||||||||||||||||||||||||||||||
| 6 | 1.67 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"blacked blacked"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.49 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"blacked blacked"
]
|
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.