Query Metrics
7
Database Queries
7
Different statements
177.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.77 ms (85.92%) |
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 45136 187699 396234 402984 402987 403003 403010 404722 406237 413529 418817 419134 428051 430638 437218 442218 442233 442237 442254 442262 442285 442325 442339 442771 442773 442809 442810 442836 444235 448095 453097 454200 454237 456778 456799 457281 461213 463238 463823 467351 468095 472906 473493 474077 474161 478450 478821 478824 481955 484016 485457 485751 487892 488211 489769 489847 491017 492332 492396 496282 503683 506580 512180 514688 515634 516003 516304 516430 521226 523760 523763 526516 527287 529088 529351 529492 532511 535029 535540 543567 545498 546375 546936 547791 554542 558446 560523 563094 572806 572865 573376 578173 583835 587070 588319 592762 598949 600347 663909 663944 665317 667498 667636 693967 707464 707546 720121 724263 737124 738367 740647 741733 742385 758234 772126 788852 791012 801974 809293 819593 ] |
||||||||||||||||||||||||||||||
|
15.93 ms (8.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 442771 489769 474161 535029 532511 523763 560523 667636 667498 707464 598949 740647 758234 724263 448095 45136 402984 430638 516304 492332 187699 444235 442836 463238 484016 512180 529351 461213 558446 573376 707546 583835 588319 600347 809293 738367 741733 772126 742385 402987 478450 413529 454237 468095 496282 403003 428051 491017 487892 488211 516430 523760 515634 529088 527287 529492 485457 546936 578173 665317 663909 693967 545498 563094 737124 788852 720121 791012 801974 473493 437218 478824 418817 478821 467351 514688 506580 526516 419134 442218 442809 456778 442233 454200 457281 474077 485751 492396 572865 592762 587070 404722 442237 442254 403010 442325 442339 442773 535540 442810 442262 453097 472906 481955 456799 463823 503683 543567 554542 663944 546375 396234 406237 442285 489847 516003 819593 521226 547791 572806 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.29%) |
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 45136 187699 396234 402984 402987 403003 403010 404722 406237 413529 418817 419134 428051 430638 437218 442218 442233 442237 442254 442262 442285 442325 442339 442771 442773 442809 442810 442836 444235 448095 453097 454200 454237 456778 456799 457281 461213 463238 463823 467351 468095 472906 473493 474077 474161 478450 478821 478824 481955 484016 485457 485751 487892 488211 489769 489847 491017 492332 492396 496282 503683 506580 512180 514688 515634 516003 516304 516430 521226 523760 523763 526516 527287 529088 529351 529492 532511 535029 535540 543567 545498 546375 546936 547791 554542 558446 560523 563094 572806 572865 573376 578173 583835 587070 588319 592762 598949 600347 663909 663944 665317 667498 667636 693967 707464 707546 720121 724263 737124 738367 740647 741733 742385 758234 772126 788852 791012 801974 809293 819593 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big lady"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие lady"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие lady"
]
|
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.