Query Metrics
7
Database Queries
7
Different statements
174.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.28 ms (84.54%) |
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 390898 426433 426806 427086 429231 442558 454677 457418 460739 461644 462101 466124 470523 482913 486520 488138 492703 493456 494148 494202 495772 498198 500176 501772 501795 506436 507193 507220 512495 512658 517125 519073 519713 522498 522813 523871 524607 525311 526704 527329 528811 552463 555933 557972 559518 562194 568349 570218 570459 572037 575164 579188 595854 596412 596423 599531 600489 601630 601869 601884 608347 609248 609268 609274 610694 616856 617869 618476 619223 619520 619920 620644 623003 629766 631302 636270 637444 641011 653244 653458 659394 675705 676444 677028 686514 693302 705226 721124 721368 721427 721487 721721 722751 722851 722871 727400 738904 741279 741958 741996 742404 746141 757549 762514 765278 777782 781678 781743 781752 784970 785761 786428 793959 816736 817782 819921 823165 823647 824612 827919 ] |
||||||||||||||||||||||||||||||
|
17.56 ms (10.08%) |
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 781678 653244 601884 827919 784970 765278 738904 528811 526704 462101 676444 570218 686514 617869 777782 793959 486520 741958 721368 781752 741996 757549 721124 677028 429231 559518 442558 519713 741279 493456 570459 693302 601869 781743 746141 786428 600489 575164 426433 498198 721427 623003 705226 721487 609268 785761 501772 595854 636270 488138 507220 653458 461644 523871 501795 525311 609274 619223 641011 609248 596423 608347 507193 512495 616856 721721 454677 610694 482913 495772 390898 426806 500176 817782 659394 675705 631302 619520 552463 637444 727400 618476 527329 517125 601630 557972 555933 470523 494148 579188 722751 596412 742404 722851 519073 524607 572037 629766 492703 620644 722871 824612 599531 427086 506436 494202 522498 568349 619920 823647 819921 512658 816736 457418 762514 466124 522813 460739 823165 562194 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.65%) |
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 390898 426433 426806 427086 429231 442558 454677 457418 460739 461644 462101 466124 470523 482913 486520 488138 492703 493456 494148 494202 495772 498198 500176 501772 501795 506436 507193 507220 512495 512658 517125 519073 519713 522498 522813 523871 524607 525311 526704 527329 528811 552463 555933 557972 559518 562194 568349 570218 570459 572037 575164 579188 595854 596412 596423 599531 600489 601630 601869 601884 608347 609248 609268 609274 610694 616856 617869 618476 619223 619520 619920 620644 623003 629766 631302 636270 637444 641011 653244 653458 659394 675705 676444 677028 686514 693302 705226 721124 721368 721427 721487 721721 722751 722851 722871 727400 738904 741279 741958 741996 742404 746141 757549 762514 765278 777782 781678 781743 781752 784970 785761 786428 793959 816736 817782 819921 823165 823647 824612 827919 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"massage sex russian"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"массаж секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"массаж секс русск"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.