Query Metrics
7
Database Queries
7
Different statements
150.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.47 ms (83.89%) |
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 412627 413648 424224 426881 428793 435590 438446 444052 444331 451305 456887 465727 471335 475014 475028 475733 480671 484533 486617 494667 499198 508578 511847 512155 513813 513831 515948 528632 531373 544980 547563 547586 547796 553315 554408 554930 554986 556155 558103 558160 560684 561507 567604 569572 577310 577777 583801 583992 584360 585050 588186 588334 590528 590644 592206 592244 594050 596637 601777 602255 605108 606856 607985 614797 616199 616231 617686 621079 629717 637487 639127 641386 650272 652500 655598 660043 663281 672821 679213 680931 681484 694602 697958 698882 705201 710174 714316 729466 733429 739500 740582 742457 750757 759072 760411 765680 768490 768497 772166 780303 781417 782563 783020 783851 784644 785670 790689 800381 801627 803129 804932 808153 808349 808968 810081 810520 811271 812007 812547 812556 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (9.15%) |
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 672821 698882 714316 663281 588334 742457 639127 790689 781417 435590 471335 451305 475014 508578 531373 583992 655598 694602 650272 652500 705201 660043 681484 697958 607985 590644 606856 594050 616199 783020 801627 804932 812007 783851 808349 808968 759072 768490 772166 782563 810520 812547 768497 760411 750757 740582 621079 780303 800381 808153 812556 554986 465727 484533 499198 547796 560684 547563 547586 569572 679213 554408 556155 577777 583801 588186 616231 592206 590528 601777 592244 596637 784644 811271 739500 602255 605108 614797 617686 710174 438446 475028 513831 511847 513813 585050 558160 567604 426881 413648 637487 629717 424224 456887 412627 515948 486617 512155 554930 444052 444331 475733 584360 785670 765680 544980 577310 558103 553315 803129 494667 680931 641386 810081 733429 428793 480671 561507 528632 729466 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.75%) |
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 412627 413648 424224 426881 428793 435590 438446 444052 444331 451305 456887 465727 471335 475014 475028 475733 480671 484533 486617 494667 499198 508578 511847 512155 513813 513831 515948 528632 531373 544980 547563 547586 547796 553315 554408 554930 554986 556155 558103 558160 560684 561507 567604 569572 577310 577777 583801 583992 584360 585050 588186 588334 590528 590644 592206 592244 594050 596637 601777 602255 605108 606856 607985 614797 616199 616231 617686 621079 629717 637487 639127 641386 650272 652500 655598 660043 663281 672821 679213 680931 681484 694602 697958 698882 705201 710174 714316 729466 733429 739500 740582 742457 750757 759072 760411 765680 768490 768497 772166 780303 781417 782563 783020 783851 784644 785670 790689 800381 801627 803129 804932 808153 808349 808968 810081 810520 811271 812007 812547 812556 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo panties wife"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло трусик нижн бел жен"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло трусик нижн бел жен"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.12%) |
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.