Query Metrics
7
Database Queries
7
Different statements
370.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.22 ms (56.98%) |
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 389966 390571 395666 396308 400491 400494 400517 400838 400988 400993 400995 405028 411321 411356 411916 415546 416072 418427 421900 422158 422171 422340 422353 424451 424482 424660 426691 442997 443635 444003 444238 445792 445864 450847 453099 453558 454170 454563 457303 462096 462695 462700 464342 464681 464956 466015 466207 467248 467273 470043 470772 475796 476260 476347 477389 477455 477727 479499 484157 485777 486815 488439 490188 490192 490581 491411 491986 493104 494329 501569 502060 504864 505888 506044 508308 508735 510839 511925 513329 513521 514681 515257 517478 517831 518617 518866 518869 518870 519752 521356 522760 522972 523591 524900 525132 528621 529409 536472 546063 546623 549234 550232 552080 552307 554465 558286 559116 561512 561576 563225 563616 598877 665383 668641 678764 726487 726543 726553 726594 766616 ] |
||||||||||||||||||||||||||||||
|
133.45 ms (36.00%) |
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 389966 390571 395666 396308 400491 400494 400517 400838 400988 400993 400995 405028 411321 411356 411916 415546 416072 418427 421900 422158 422171 422340 422353 424451 424482 424660 426691 442997 443635 444003 444238 445792 445864 450847 453099 453558 454170 454563 457303 462096 462695 462700 464342 464681 464956 466015 466207 467248 467273 470043 470772 475796 476260 476347 477389 477455 477727 479499 484157 485777 486815 488439 490188 490192 490581 491411 491986 493104 494329 501569 502060 504864 505888 506044 508308 508735 510839 511925 513329 513521 514681 515257 517478 517831 518617 518866 518869 518870 519752 521356 522760 522972 523591 524900 525132 528621 529409 536472 546063 546623 549234 550232 552080 552307 554465 558286 559116 561512 561576 563225 563616 598877 665383 668641 678764 726487 726543 726553 726594 766616 ] |
||||||||||||||||||||||||||||||
|
18.96 ms (5.11%) |
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 476347 490188 490581 445864 457303 476260 514681 521356 502060 501569 510839 491411 552080 554465 561512 563225 563616 665383 546623 549234 550232 598877 766616 726594 400988 442997 470772 400494 411321 411916 466207 400993 424451 400517 415546 426691 470043 411356 454563 467273 505888 508308 488439 506044 517831 493104 519752 491986 513521 518869 528621 453558 445792 523591 464681 467248 561576 484157 444238 396308 422340 462096 464342 477727 453099 464956 486815 529409 536472 524900 511925 525132 559116 552307 546063 558286 678764 668641 726543 726553 390571 400995 462695 400838 477455 479499 422158 424482 477389 421900 454170 466015 504864 518866 522760 508735 513329 517478 518617 485777 490192 518870 494329 475796 416072 418427 450847 515257 726487 422171 389966 400491 424660 405028 522972 395666 422353 462700 444003 443635 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"chubby young girl"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"chubby young девушк"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"chubby young девушк"
]
|
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.