Query Metrics
7
Database Queries
7
Different statements
362.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.03 ms (58.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mouth 18 сперм"
]
|
||||||||||||||||||||||||||||||
|
130.28 ms (35.97%) |
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 390790 399936 402771 437994 471925 496688 497797 506217 540272 547225 552562 557029 586221 588508 590217 597150 606005 608860 612973 620750 628181 632886 641227 650031 658225 680492 697727 701255 701276 701987 702635 705050 709700 710822 715746 717922 719130 719752 719756 722120 722189 723432 726373 728625 728853 729342 729441 733598 735307 738569 740231 741174 741672 743348 746117 748429 749176 749307 754253 755049 757934 760230 760942 762529 763518 764961 765100 765386 767358 768190 769057 772276 773757 774058 774794 777212 777316 777497 777612 777693 778036 778054 778625 779075 779089 779551 779716 781013 781188 781325 781399 781441 781482 781533 782638 783024 783515 784060 786587 786750 787417 787518 787888 789870 790256 792814 793442 794792 797929 797931 800523 802009 802685 804381 804884 804926 808908 810065 810592 811244 ] |
||||||||||||||||||||||||||||||
|
12.36 ms (3.41%) |
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 709700 715746 722120 547225 586221 597150 608860 612973 632886 777693 778054 783515 784060 787518 804884 810592 777212 777497 778036 779551 779716 781188 781325 792814 793442 797929 729441 741174 749176 749307 764961 769057 781399 781441 781533 783024 786587 786750 787417 802009 804381 804926 810065 811244 757934 760230 741672 768190 726373 728853 729342 755049 762529 765386 772276 773757 735307 743348 748429 763518 767358 774058 620750 697727 701276 701987 717922 719130 722189 777612 781013 781482 787888 794792 802685 402771 552562 471925 705050 701255 710822 779075 782638 797931 765100 740231 754253 641227 779089 399936 437994 800523 738569 760942 733598 390790 557029 590217 789870 808908 728625 746117 506217 497797 540272 658225 702635 774794 496688 650031 719756 680492 719752 723432 628181 588508 606005 790256 777316 778625 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (0.82%) |
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 390790 399936 402771 437994 471925 496688 497797 506217 540272 547225 552562 557029 586221 588508 590217 597150 606005 608860 612973 620750 628181 632886 641227 650031 658225 680492 697727 701255 701276 701987 702635 705050 709700 710822 715746 717922 719130 719752 719756 722120 722189 723432 726373 728625 728853 729342 729441 733598 735307 738569 740231 741174 741672 743348 746117 748429 749176 749307 754253 755049 757934 760230 760942 762529 763518 764961 765100 765386 767358 768190 769057 772276 773757 774058 774794 777212 777316 777497 777612 777693 778036 778054 778625 779075 779089 779551 779716 781013 781188 781325 781399 781441 781482 781533 782638 783024 783515 784060 786587 786750 787417 787518 787888 789870 790256 792814 793442 794792 797929 797931 800523 802009 802685 804381 804884 804926 808908 810065 810592 811244 ] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mouth 18 sperm"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mouth 18 сперм"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.41%) |
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.