Query Metrics
7
Database Queries
7
Different statements
148.09 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.50 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.19 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"curvy chubby"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.01 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 481386 400847 403891 440826 450287 478933 448104 452757 457577 458985 459338 452189 457569 475296 487011 503565 505692 515034 525503 509637 510107 522628 527476 527779 577394 697457 564054 607640 586520 607716 618611 812911 463159 411807 421773 401137 488954 513138 405114 458427 490188 526213 532629 495579 526761 535303 569153 577402 552955 572843 809153 705424 422053 453705 465546 453686 430818 509590 526757 449880 455259 459620 456168 512541 524051 510843 525859 501529 475247 541239 579707 569133 668668 607694 607552 450990 456607 503556 438284 569544 674986 455749 429990 448954 634885 427543 698124 610588 527908 ] |
||||||||||||||||||||||||||||||
| 4 | 2.79 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 400847 401137 403891 405114 411807 421773 422053 427543 429990 430818 438284 440826 448104 448954 449880 450287 450990 452189 452757 453686 453705 455259 455749 456168 456607 457569 457577 458427 458985 459338 459620 463159 465546 475247 475296 478933 481386 487011 488954 490188 495579 501529 503556 503565 505692 509590 509637 510107 510843 512541 513138 515034 522628 524051 525503 525859 526213 526757 526761 527476 527779 527908 532629 535303 541239 552955 564054 569133 569153 569544 572843 577394 577402 579707 586520 607552 607640 607694 607716 610588 618611 634885 668668 674986 697457 698124 705424 809153 812911 ] |
||||||||||||||||||||||||||||||
| 5 | 123.24 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 400847 401137 403891 405114 411807 421773 422053 427543 429990 430818 438284 440826 448104 448954 449880 450287 450990 452189 452757 453686 453705 455259 455749 456168 456607 457569 457577 458427 458985 459338 459620 463159 465546 475247 475296 478933 481386 487011 488954 490188 495579 501529 503556 503565 505692 509590 509637 510107 510843 512541 513138 515034 522628 524051 525503 525859 526213 526757 526761 527476 527779 527908 532629 535303 541239 552955 564054 569133 569153 569544 572843 577394 577402 579707 586520 607552 607640 607694 607716 610588 618611 634885 668668 674986 697457 698124 705424 809153 812911 ] |
||||||||||||||||||||||||||||||
| 6 | 1.84 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"curvy chubby"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.53 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"curvy chubby"
]
|
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.