Query Metrics
7
Database Queries
7
Different statements
158.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.20 ms (80.45%) |
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 117513 384462 385416 396326 396928 400732 401213 403896 412930 413238 420220 420230 420808 421103 422529 422558 422621 422924 423010 423261 423398 426171 428518 429276 434842 435635 435759 443497 443598 443992 445233 445472 451981 456635 456636 456637 458094 458101 465194 477216 480511 488816 491512 512216 514341 515279 516430 529436 530709 532596 542219 545473 546864 551992 554343 558391 558421 558576 559159 559914 565205 565222 568869 569824 574467 580100 584721 586642 595943 596773 596860 597263 603082 605919 609847 609909 614079 614731 618483 630930 632727 637251 641452 644363 650835 652127 654452 658555 672031 674216 680753 705547 713139 715125 729065 731456 734675 740928 741621 742132 743426 743436 745265 750448 750449 754204 755341 762382 774294 785021 793630 800303 802533 808732 809163 811267 811858 812879 814198 828321 ] |
||||||||||||||||||||||||||||||
|
21.02 ms (13.29%) |
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 658555 705547 614079 596860 603082 630930 596773 811267 729065 750448 745265 750449 741621 609847 632727 715125 117513 396326 546864 403896 423261 434842 429276 435759 443992 412930 443497 422924 443598 465194 456637 445472 451981 516430 558391 551992 574467 618483 401213 422529 445233 420808 423398 422558 529436 488816 491512 515279 512216 400732 420220 480511 514341 532596 545473 558421 542219 565205 554343 558576 569824 584721 654452 680753 652127 674216 559914 565222 580100 605919 586642 614731 595943 609909 637251 641452 785021 809163 740928 793630 802533 808732 811858 731456 774294 743436 755341 762382 754204 644363 800303 812879 420230 384462 568869 672031 650835 713139 742132 743426 734675 458094 426171 477216 828321 423010 530709 559159 597263 421103 385416 396928 413238 422621 428518 435635 814198 456635 456636 458101 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.67%) |
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 117513 384462 385416 396326 396928 400732 401213 403896 412930 413238 420220 420230 420808 421103 422529 422558 422621 422924 423010 423261 423398 426171 428518 429276 434842 435635 435759 443497 443598 443992 445233 445472 451981 456635 456636 456637 458094 458101 465194 477216 480511 488816 491512 512216 514341 515279 516430 529436 530709 532596 542219 545473 546864 551992 554343 558391 558421 558576 559159 559914 565205 565222 568869 569824 574467 580100 584721 586642 595943 596773 596860 597263 603082 605919 609847 609909 614079 614731 618483 630930 632727 637251 641452 644363 650835 652127 654452 658555 672031 674216 680753 705547 713139 715125 729065 731456 734675 740928 741621 742132 743426 743436 745265 750448 750449 754204 755341 762382 774294 785021 793630 800303 802533 808732 809163 811267 811858 812879 814198 828321 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaved asian"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бритая азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.