Query Metrics
7
Database Queries
7
Different statements
152.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.50 ms (81.86%) |
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 51456 304572 415546 415615 415917 423731 423974 429479 436235 445879 445881 445895 446566 451802 453075 453131 455294 456786 457058 457688 466552 466930 476448 480740 481019 483569 505691 507767 507902 509205 510253 513084 515858 518547 518558 518589 521262 521462 521514 521783 522441 522744 523516 523815 524574 525497 526193 527232 527622 527678 528202 528402 528791 529180 531172 531206 532684 541551 548609 548751 558129 560505 561454 562731 564175 564716 565866 566889 567721 568105 569111 569274 570910 571841 574884 581035 581221 584088 585171 586219 589723 591141 593016 597599 598292 599113 600607 601072 601387 601634 603269 613872 622990 628114 631962 633444 636811 650955 681182 681310 699531 707539 714549 716157 724183 729180 733486 742449 746995 748889 755652 756747 775976 790794 807374 810933 813250 815115 818167 822692 ] |
||||||||||||||||||||||||||||||
|
17.48 ms (11.49%) |
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 453131 457688 453075 518589 562731 423731 815115 541551 561454 560505 565866 569111 600607 636811 755652 451802 523516 483569 429479 822692 570910 581035 613872 589723 631962 742449 746995 707539 714549 716157 813250 415917 522744 510253 699531 532684 756747 593016 455294 513084 650955 601634 436235 584088 525497 445895 466930 527622 480740 515858 509205 807374 748889 775976 423974 527678 456786 518547 569274 581221 568105 628114 446566 415546 529180 481019 531206 564175 558129 599113 622990 597599 466552 51456 729180 304572 591141 601072 567721 574884 603269 790794 810933 524574 522441 586219 521462 445879 457058 528402 505691 476448 598292 521262 528202 548609 601387 527232 507767 523815 818167 531172 681310 633444 548751 564716 733486 566889 585171 724183 445881 526193 681182 528791 521783 571841 507902 518558 521514 415615 ] |
||||||||||||||||||||||||||||||
|
3.62 ms (2.38%) |
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 51456 304572 415546 415615 415917 423731 423974 429479 436235 445879 445881 445895 446566 451802 453075 453131 455294 456786 457058 457688 466552 466930 476448 480740 481019 483569 505691 507767 507902 509205 510253 513084 515858 518547 518558 518589 521262 521462 521514 521783 522441 522744 523516 523815 524574 525497 526193 527232 527622 527678 528202 528402 528791 529180 531172 531206 532684 541551 548609 548751 558129 560505 561454 562731 564175 564716 565866 566889 567721 568105 569111 569274 570910 571841 574884 581035 581221 584088 585171 586219 589723 591141 593016 597599 598292 599113 600607 601072 601387 601634 603269 613872 622990 628114 631962 633444 636811 650955 681182 681310 699531 707539 714549 716157 724183 729180 733486 742449 746995 748889 755652 756747 775976 790794 807374 810933 813250 815115 818167 822692 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hand job horny"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член horny"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дрочк член horny"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.