Query Metrics
7
Database Queries
7
Different statements
195.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.87 ms (86.48%) |
1 |
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 387647 400458 424853 426634 432518 433402 436841 450118 450127 450129 450149 450166 453984 455419 455770 457004 460033 460905 461811 469693 470060 475861 477794 480011 499556 509010 511225 512763 515734 528054 536967 545490 552209 552334 560457 563320 563425 565328 570144 571732 572446 579213 579542 584275 588373 589085 591544 594821 599199 601835 603085 605002 607481 608273 613224 621225 625233 627168 635041 639279 645520 668275 672822 680625 680794 682329 693410 701613 709476 709586 713731 715152 718739 721096 721773 721968 724475 725476 727393 727771 731005 731177 732689 734687 735604 736382 736775 740512 744790 745552 751111 758158 759074 761012 763896 768902 770494 775083 777172 777316 781001 783353 786973 788327 791203 791567 796147 796538 797006 798469 799431 799933 800906 800970 802631 805000 805238 807669 809519 ] |
||||||||||||||||||||||||||||||
|
17.30 ms (8.86%) |
1 |
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 796147 805238 799431 807669 736382 727393 731005 745552 768902 709586 721096 797006 475861 450118 469693 515734 590749 599199 457004 528054 536967 499556 512763 509010 571732 645520 721968 718739 672822 680625 721773 579542 613224 591544 588373 594821 625233 627168 777316 786973 800970 744790 788327 724475 735604 759074 763896 758158 725476 761012 713731 715152 436841 460905 424853 460033 470060 461811 387647 400458 426634 450129 450166 453984 450127 450149 455419 511225 563320 570144 552209 560457 563425 565328 572446 579213 584275 680794 682329 693410 701613 668275 545490 552334 589085 607481 621225 635041 601835 603085 605002 608273 775083 781001 791203 791567 802631 796538 798469 799933 805000 809519 731177 751111 770494 732689 736775 740512 727771 734687 639279 709476 777172 783353 800906 432518 433402 477794 480011 455770 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.22%) |
1 |
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 387647 400458 424853 426634 432518 433402 436841 450118 450127 450129 450149 450166 453984 455419 455770 457004 460033 460905 461811 469693 470060 475861 477794 480011 499556 509010 511225 512763 515734 528054 536967 545490 552209 552334 560457 563320 563425 565328 570144 571732 572446 579213 579542 584275 588373 589085 591544 594821 599199 601835 603085 605002 607481 608273 613224 621225 625233 627168 635041 639279 645520 668275 672822 680625 680794 682329 693410 701613 709476 709586 713731 715152 718739 721096 721773 721968 724475 725476 727393 727771 731005 731177 732689 734687 735604 736382 736775 740512 744790 745552 751111 758158 759074 761012 763896 768902 770494 775083 777172 777316 781001 783353 786973 788327 791203 791567 796147 796538 797006 798469 799431 799933 800906 800970 802631 805000 805238 807669 809519 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum sexy"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum sexy"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum sexy"
]
|
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.