Query Metrics
7
Database Queries
7
Different statements
221.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.27 ms (87.22%) |
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 53992 122914 214988 382649 389899 390255 394376 395249 398053 400237 405846 415903 418009 418188 420067 421262 422844 423023 424056 424946 425027 427447 428479 431323 433610 435629 438765 445252 446870 447826 448640 457253 458327 458429 460710 473763 475443 478030 483708 492412 492805 499035 501252 505384 511249 513136 515891 517997 519907 522123 523326 523712 525605 527117 532252 533388 534776 535434 536970 550615 551017 551066 551946 552037 552915 554791 556662 557519 558372 559923 566007 566011 581393 581972 586002 586627 587530 588221 590959 590978 592734 593396 598621 600605 603193 603576 605380 605430 606681 610198 622076 622628 622629 623813 634312 635659 643472 643886 643975 649168 650957 691221 708472 713550 714119 720943 741109 747984 748684 749532 759782 760232 792311 804300 808754 816360 816844 818299 818335 819390 ] |
||||||||||||||||||||||||||||||
|
17.57 ms (7.93%) |
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 708472 713550 552915 610198 622076 635659 643472 622629 643975 749532 760232 643886 425027 418009 438765 511249 622628 424056 395249 382649 819390 457253 522123 581393 554791 559923 566011 552037 420067 214988 550615 600605 588221 792311 804300 394376 389899 423023 428479 424946 421262 435629 478030 492805 458429 448640 460710 499035 527117 535434 523712 532252 534776 581972 691221 714119 556662 606681 587530 592734 605430 590959 603193 586002 590978 634312 741109 748684 418188 400237 433610 475443 422844 122914 390255 398053 405846 431323 415903 818299 816360 818335 473763 447826 492412 533388 513136 525605 536970 517997 551946 566007 551017 551066 558372 650957 649168 557519 598621 603576 593396 605380 586627 808754 747984 759782 720943 53992 446870 445252 483708 505384 501252 523326 427447 458327 515891 519907 623813 816844 ] |
||||||||||||||||||||||||||||||
|
3.58 ms (1.62%) |
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 53992 122914 214988 382649 389899 390255 394376 395249 398053 400237 405846 415903 418009 418188 420067 421262 422844 423023 424056 424946 425027 427447 428479 431323 433610 435629 438765 445252 446870 447826 448640 457253 458327 458429 460710 473763 475443 478030 483708 492412 492805 499035 501252 505384 511249 513136 515891 517997 519907 522123 523326 523712 525605 527117 532252 533388 534776 535434 536970 550615 551017 551066 551946 552037 552915 554791 556662 557519 558372 559923 566007 566011 581393 581972 586002 586627 587530 588221 590959 590978 592734 593396 598621 600605 603193 603576 605380 605430 606681 610198 622076 622628 622629 623813 634312 635659 643472 643886 643975 649168 650957 691221 708472 713550 714119 720943 741109 747984 748684 749532 759782 760232 792311 804300 808754 816360 816844 818299 818335 819390 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy азиатк"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy asian"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy азиатк"
]
|
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.