Query Metrics
7
Database Queries
7
Different statements
183.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.97 ms (87.16%) |
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 263335 366012 383333 383409 384906 387104 388440 388825 390455 390530 390664 391070 391649 396471 396980 400681 403378 423912 424002 427553 434430 436530 441760 441920 442663 445423 449466 451853 455422 455494 457633 460362 461665 463015 465504 465659 466417 469816 473334 474968 475849 477795 480712 486981 490433 497748 498550 501384 501440 501680 506363 506428 507739 508226 509009 509894 510190 510423 510907 513364 517383 518242 518634 520083 520983 521696 522401 522531 523182 523296 525661 526900 529840 529960 529971 530588 530818 530823 531980 532418 532774 533286 534363 535533 535564 536522 537794 538071 538093 538192 538562 538615 540248 542296 542624 543003 543257 543481 546662 553653 583092 590129 610549 613780 614516 621056 706654 734575 738856 747885 784157 823866 826215 826290 826413 826730 828280 828301 ] |
||||||||||||||||||||||||||||||
|
13.44 ms (7.32%) |
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 517383 523296 747885 535564 822849 530588 530818 767592 828301 383409 388825 442663 461665 469816 473334 449466 535533 508226 538071 521696 475849 583092 614516 590129 621056 784157 388440 390664 423912 465504 480712 263335 441760 445423 466417 477795 400681 455494 451853 455422 463015 474968 510190 510423 520083 498550 509009 525661 490433 497748 529840 542296 542624 610549 826730 522531 531980 522401 532774 546662 706654 538615 530823 537794 465659 543481 543003 543257 391070 390455 390530 396980 403378 427553 436530 457633 510907 518242 540248 501680 506363 529960 534363 526900 529971 538093 507739 553653 613780 424002 434430 441920 383333 460362 523182 501440 509894 518634 486981 501384 520983 384906 391649 387104 396471 826215 826290 826413 823866 828280 533286 506428 513364 538192 538562 532418 536522 734575 738856 366012 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.45%) |
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 263335 366012 383333 383409 384906 387104 388440 388825 390455 390530 390664 391070 391649 396471 396980 400681 403378 423912 424002 427553 434430 436530 441760 441920 442663 445423 449466 451853 455422 455494 457633 460362 461665 463015 465504 465659 466417 469816 473334 474968 475849 477795 480712 486981 490433 497748 498550 501384 501440 501680 506363 506428 507739 508226 509009 509894 510190 510423 510907 513364 517383 518242 518634 520083 520983 521696 522401 522531 523182 523296 525661 526900 529840 529960 529971 530588 530818 530823 531980 532418 532774 533286 534363 535533 535564 536522 537794 538071 538093 538192 538562 538615 540248 542296 542624 543003 543257 543481 546662 553653 583092 590129 610549 613780 614516 621056 706654 734575 738856 747885 784157 823866 826215 826290 826413 826730 828280 828301 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white riding"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white riding"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white riding"
]
|
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.