Query Metrics
7
Database Queries
7
Different statements
412.26 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.52 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 205.02 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf dress"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.73 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 490413 505266 605096 447935 411459 488240 516623 526585 472185 564177 564227 675675 675060 675660 687586 660416 675066 675104 675723 579171 605093 605133 605219 604961 605255 605074 600781 605026 604994 604995 483637 493183 510078 574422 605152 440601 427601 489936 524083 525760 579336 547494 675081 675429 675431 675696 675430 669361 675071 675126 675657 605238 589795 591983 507647 488389 508242 486587 491932 523023 439790 521156 523181 547473 564122 606377 605117 439432 513477 500797 540794 516633 539498 559187 675435 675123 440998 520448 589690 629428 603286 604990 586591 605298 560786 605111 602658 ] |
||||||||||||||||||||||||||||||
| 4 | 3.46 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 411459 427601 439432 439790 440601 440998 447935 472185 483637 486587 488240 488389 489936 490413 491932 493183 500797 505266 507647 508242 510078 513477 516623 516633 520448 521156 523023 523181 524083 525760 526585 539498 540794 547473 547494 559187 560786 564122 564177 564227 574422 579171 579336 586591 589690 589795 591983 600781 602658 603286 604961 604990 604994 604995 605026 605074 605093 605096 605111 605117 605133 605152 605219 605238 605255 605298 606377 629428 660416 669361 675060 675066 675071 675081 675104 675123 675126 675429 675430 675431 675435 675657 675660 675675 675696 675723 687586 ] |
||||||||||||||||||||||||||||||
| 5 | 182.09 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 411459 427601 439432 439790 440601 440998 447935 472185 483637 486587 488240 488389 489936 490413 491932 493183 500797 505266 507647 508242 510078 513477 516623 516633 520448 521156 523023 523181 524083 525760 526585 539498 540794 547473 547494 559187 560786 564122 564177 564227 574422 579171 579336 586591 589690 589795 591983 600781 602658 603286 604961 604990 604994 604995 605026 605074 605093 605096 605111 605117 605133 605152 605219 605238 605255 605298 606377 629428 660416 669361 675060 675066 675071 675081 675104 675123 675126 675429 675430 675431 675435 675657 675660 675675 675696 675723 687586 ] |
||||||||||||||||||||||||||||||
| 6 | 1.99 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf dress"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.45 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf dress"
]
|
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.