Query Metrics
7
Database Queries
7
Different statements
181.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.60 ms (79.47%) |
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 264016 382181 388320 392623 395386 397506 400417 402260 417956 418659 421806 426959 456961 457180 459793 460802 461392 467245 467348 474803 485035 485170 488332 488558 500510 504529 507014 508832 508845 517266 517309 521702 524172 524313 527583 529573 540381 543292 544127 545588 546078 546609 546658 546760 546826 547613 549747 549941 552072 552843 554123 554772 557402 558908 560655 565433 568809 569446 570740 572686 572718 574128 577484 582488 587587 588844 589987 591799 594971 604813 608039 614466 619075 622277 623826 624659 624662 625855 626112 626771 636936 636951 637654 640457 640458 646693 650648 652258 653755 653888 656106 662387 662974 663538 664210 668789 668808 671175 671877 675456 676972 677048 679231 680492 684198 692592 693302 698372 711604 716280 717696 722536 722882 723632 774468 815263 815841 820695 823346 826327 ] |
||||||||||||||||||||||||||||||
|
27.38 ms (15.05%) |
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 392623 397506 467245 418659 461392 417956 474803 507014 508832 488558 395386 264016 382181 388320 400417 402260 421806 426959 723632 774468 815263 820695 815841 823346 826327 456961 485170 457180 460802 459793 467348 485035 504529 508845 517266 500510 517309 529573 521702 524172 524313 527583 540381 488332 546760 549941 572686 545588 546078 549747 552072 554123 557402 574128 582488 543292 544127 546658 547613 554772 558908 568809 572718 652258 653755 653888 668789 671877 677048 692592 662387 662974 663538 664210 716280 722882 646693 650648 656106 668808 671175 675456 676972 679231 680492 684198 693302 698372 711604 717696 722536 546609 546826 552843 560655 565433 569446 570740 577484 587587 591799 619075 622277 624662 625855 626112 589987 594971 636936 636951 637654 640458 588844 604813 608039 614466 623826 624659 626771 640457 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.66%) |
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 264016 382181 388320 392623 395386 397506 400417 402260 417956 418659 421806 426959 456961 457180 459793 460802 461392 467245 467348 474803 485035 485170 488332 488558 500510 504529 507014 508832 508845 517266 517309 521702 524172 524313 527583 529573 540381 543292 544127 545588 546078 546609 546658 546760 546826 547613 549747 549941 552072 552843 554123 554772 557402 558908 560655 565433 568809 569446 570740 572686 572718 574128 577484 582488 587587 588844 589987 591799 594971 604813 608039 614466 619075 622277 623826 624659 624662 625855 626112 626771 636936 636951 637654 640457 640458 646693 650648 652258 653755 653888 656106 662387 662974 663538 664210 668789 668808 671175 671877 675456 676972 677048 679231 680492 684198 692592 693302 698372 711604 716280 717696 722536 722882 723632 774468 815263 815841 820695 823346 826327 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx boyfriend"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx boyfriend"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx boyfriend"
]
|
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.