Query Metrics
7
Database Queries
7
Different statements
427.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.81 ms (49.05%) |
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 95668 188189 338258 382316 407157 410079 415287 434863 441406 441728 444196 444262 445188 452305 454090 458804 460683 460685 465277 465970 469276 469768 471299 477594 482730 493035 496479 503787 505085 505539 507653 511255 512875 517344 517469 518026 518633 520820 523279 525287 526247 526265 528023 528489 533968 534748 546746 549534 550787 554295 557562 557915 560282 569632 572355 573411 578304 581025 584431 586510 591186 591550 595137 604270 606549 607465 619746 619751 620117 622672 623037 624990 626165 628982 630267 635845 636242 640411 661060 666434 679909 682417 691200 693359 695908 697182 711345 714795 718441 720589 721230 724495 726882 735939 743086 750940 752920 753204 761466 761510 763890 764003 764234 771571 773565 773908 773974 785921 785945 791186 793663 794398 797128 797709 798183 800295 807701 808064 812992 816803 ] |
||||||||||||||||||||||||||||||
|
197.96 ms (46.28%) |
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 95668 188189 338258 382316 407157 410079 415287 434863 441406 441728 444196 444262 445188 452305 454090 458804 460683 460685 465277 465970 469276 469768 471299 477594 482730 493035 496479 503787 505085 505539 507653 511255 512875 517344 517469 518026 518633 520820 523279 525287 526247 526265 528023 528489 533968 534748 546746 549534 550787 554295 557562 557915 560282 569632 572355 573411 578304 581025 584431 586510 591186 591550 595137 604270 606549 607465 619746 619751 620117 622672 623037 624990 626165 628982 630267 635845 636242 640411 661060 666434 679909 682417 691200 693359 695908 697182 711345 714795 718441 720589 721230 724495 726882 735939 743086 750940 752920 753204 761466 761510 763890 764003 764234 771571 773565 773908 773974 785921 785945 791186 793663 794398 797128 797709 798183 800295 807701 808064 812992 816803 ] |
||||||||||||||||||||||||||||||
|
12.68 ms (2.96%) |
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 679909 661060 743086 410079 469768 591186 752920 714795 595137 635845 640411 797709 794398 735939 460683 95668 793663 750940 761510 630267 458804 505539 572355 382316 550787 771571 808064 445188 496479 526265 718441 666434 697182 773908 493035 518633 525287 791186 724495 711345 800295 415287 693359 753204 338258 682417 721230 546746 623037 785921 505085 188189 534748 720589 636242 764003 764234 807701 578304 695908 761466 460685 528023 785945 773974 407157 554295 560282 557562 619751 763890 465277 604270 607465 606549 444196 517344 526247 441406 434863 503787 798183 444262 557915 797128 477594 469276 626165 586510 482730 569632 726882 528489 533968 584431 465970 511255 628982 520820 619746 773565 816803 549534 573411 622672 812992 454090 523279 517469 620117 512875 624990 441728 507653 591550 518026 691200 471299 581025 452305 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (0.55%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie секс"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie fuck"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.36%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie секс"
]
|
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.