Query Metrics
7
Database Queries
7
Different statements
208.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.30 ms (87.65%) |
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 61969 62251 114640 163762 187516 247538 247545 248388 382031 383888 389848 390981 392159 409082 409613 411861 415691 421420 423943 424048 425505 426494 432884 433379 434024 435737 440526 441295 448752 452454 466859 468159 480314 484611 488923 499013 502201 507191 512450 533930 535294 538459 542080 545491 551963 554158 556504 557254 557507 560699 560710 565736 566627 567313 569103 573219 578391 581196 585419 587103 588399 601404 601683 604826 613414 616648 618680 621200 627344 628648 628667 649487 658920 658924 663990 665199 666734 667845 667972 672369 680682 686133 689042 692378 693935 704121 709460 709549 730288 740545 751067 751354 755488 759139 759146 763283 765794 768884 769438 774381 775669 780620 781704 781928 783745 784005 785803 786730 787064 791013 791033 792337 792765 793575 797345 800536 802488 804235 804436 812395 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (7.56%) |
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 512450 533930 535294 507191 538459 466859 557254 566627 567313 573219 578391 551963 556504 557507 542080 545491 554158 560710 658920 658924 665199 693935 667845 672369 686133 689042 692378 649487 663990 666734 667972 680682 709460 709549 560699 565736 569103 581196 587103 601404 604826 613414 585419 588399 616648 621200 628667 618680 627344 628648 781704 785803 786730 791013 802488 804436 792337 792765 812395 787064 793575 797345 800536 740545 751067 759146 763283 759139 774381 730288 755488 768884 751354 765794 769438 601683 704121 775669 780620 781928 783745 784005 791033 804235 114640 392159 424048 247538 409613 411861 425505 187516 390981 421420 423943 433379 468159 247545 248388 409082 440526 448752 452454 480314 484611 488923 499013 502201 383888 163762 382031 62251 61969 389848 426494 432884 435737 441295 415691 434024 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.49%) |
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 61969 62251 114640 163762 187516 247538 247545 248388 382031 383888 389848 390981 392159 409082 409613 411861 415691 421420 423943 424048 425505 426494 432884 433379 434024 435737 440526 441295 448752 452454 466859 468159 480314 484611 488923 499013 502201 507191 512450 533930 535294 538459 542080 545491 551963 554158 556504 557254 557507 560699 560710 565736 566627 567313 569103 573219 578391 581196 585419 587103 588399 601404 601683 604826 613414 616648 618680 621200 627344 628648 628667 649487 658920 658924 663990 665199 666734 667845 667972 672369 680682 686133 689042 692378 693935 704121 709460 709549 730288 740545 751067 751354 755488 759139 759146 763283 765794 768884 769438 774381 775669 780620 781704 781928 783745 784005 785803 786730 787064 791013 791033 792337 792765 793575 797345 800536 802488 804235 804436 812395 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shower shower"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shower shower"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shower shower"
]
|
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.