Query Metrics
7
Database Queries
7
Different statements
224.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.04 ms (89.73%) |
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 519252 522899 525529 538837 541324 541875 541884 542798 543471 543477 543480 543494 543497 544206 544277 545517 545528 546747 546943 550327 560387 561353 562826 562837 562841 562842 563530 563532 563537 564519 565102 566297 566502 566697 566857 566952 567425 568168 568287 569427 571243 572176 572544 573105 573914 574269 576631 576650 576673 576722 577366 577369 577376 578952 580253 580254 580255 581349 583897 589761 592413 592476 592530 605338 605345 609568 614441 615746 618868 619379 619409 619484 620130 620148 620934 622381 622953 624163 626732 628292 628315 628327 629326 644259 644289 644303 644310 645263 648880 649154 651190 652587 653486 670112 670113 670955 671735 671753 672175 672805 674117 691995 694058 694063 699697 703039 704533 707280 707312 709748 715670 716368 716659 723480 727794 744259 748349 749100 784247 790392 ] |
||||||||||||||||||||||||||||||
|
14.02 ms (6.26%) |
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 784247 749100 744259 727794 619484 624163 629326 644289 644303 644310 703039 716368 716659 538837 541324 543497 544206 544277 545528 562842 566297 568168 566857 571243 572176 577376 541875 561353 566952 568287 573105 648880 649154 672175 691995 694063 707280 645263 653486 670112 707312 723480 651190 671753 672805 546943 550327 620934 609568 644259 592413 748349 704533 519252 576722 542798 543477 543494 564519 569427 543480 563532 574269 670955 671735 694058 699697 715670 563530 576631 577369 580254 580255 619379 628315 618868 628292 592476 619409 620148 790392 525529 522899 546747 560387 567425 578952 562841 566697 576650 562826 580253 670113 674117 709748 545517 562837 565102 572544 573914 589761 605345 620130 622953 614441 592530 626732 605338 622381 541884 566502 576673 577366 581349 543471 652587 563537 583897 628327 615746 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.18%) |
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 519252 522899 525529 538837 541324 541875 541884 542798 543471 543477 543480 543494 543497 544206 544277 545517 545528 546747 546943 550327 560387 561353 562826 562837 562841 562842 563530 563532 563537 564519 565102 566297 566502 566697 566857 566952 567425 568168 568287 569427 571243 572176 572544 573105 573914 574269 576631 576650 576673 576722 577366 577369 577376 578952 580253 580254 580255 581349 583897 589761 592413 592476 592530 605338 605345 609568 614441 615746 618868 619379 619409 619484 620130 620148 620934 622381 622953 624163 626732 628292 628315 628327 629326 644259 644289 644303 644310 645263 648880 649154 651190 652587 653486 670112 670113 670955 671735 671753 672175 672805 674117 691995 694058 694063 699697 703039 704533 707280 707312 709748 715670 716368 716659 723480 727794 744259 748349 749100 784247 790392 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen vintage"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.65%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen vintage"
]
|
||||||||||||||||||||||||||||||
|
1.12 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen vintage"
]
|
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.