Query Metrics
7
Database Queries
7
Different statements
172.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.34 ms (84.71%) |
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 80777 218026 358438 386874 388712 389667 399641 404459 417349 421363 422353 426025 427473 430553 431365 433192 442168 442335 442831 443001 445396 447072 448801 449677 450510 450808 452010 452895 456915 457963 458100 460771 463094 464994 468054 469200 470987 472505 472506 475272 477079 481359 483352 484684 487746 488310 492338 492597 495835 503314 511810 512203 514808 517601 517687 518591 523306 523537 530513 537773 541215 551111 551262 552058 562835 562843 563093 563532 566375 568423 576707 578413 581350 587253 590850 593269 595766 595907 596556 600837 601841 605298 608930 609953 610595 613177 613737 624510 631923 639712 640696 643090 643383 644567 649225 663370 664431 664841 665140 675830 676354 676804 679092 679121 692327 716394 720364 724209 766021 766141 770824 784304 788886 801906 812790 814239 815019 815524 816007 816949 ] |
||||||||||||||||||||||||||||||
|
15.48 ms (8.96%) |
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 433192 495835 426025 581350 452895 639712 568423 624510 442168 578413 595907 457963 442335 450510 537773 593269 422353 541215 716394 676804 596556 814239 613177 484684 483352 445396 488310 605298 514808 643383 640696 600837 609953 388712 530513 477079 487746 421363 460771 595766 472505 523537 458100 456915 563093 608930 566375 389667 452010 552058 643090 766141 218026 430553 80777 386874 399641 492338 448801 518591 551262 679092 720364 692327 766021 631923 503314 417349 358438 442831 815019 816949 815524 450808 475272 665140 664431 610595 644567 601841 613737 784304 724209 469200 481359 427473 449677 523306 492597 511810 816007 468054 464994 512203 517687 576707 562843 563532 649225 675830 663370 664841 676354 679121 562835 587253 788886 812790 770824 463094 470987 431365 404459 443001 447072 517601 472506 551111 590850 801906 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (2.07%) |
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 80777 218026 358438 386874 388712 389667 399641 404459 417349 421363 422353 426025 427473 430553 431365 433192 442168 442335 442831 443001 445396 447072 448801 449677 450510 450808 452010 452895 456915 457963 458100 460771 463094 464994 468054 469200 470987 472505 472506 475272 477079 481359 483352 484684 487746 488310 492338 492597 495835 503314 511810 512203 514808 517601 517687 518591 523306 523537 530513 537773 541215 551111 551262 552058 562835 562843 563093 563532 566375 568423 576707 578413 581350 587253 590850 593269 595766 595907 596556 600837 601841 605298 608930 609953 610595 613177 613737 624510 631923 639712 640696 643090 643383 644567 649225 663370 664431 664841 665140 675830 676354 676804 679092 679121 692327 716394 720364 724209 766021 766141 770824 784304 788886 801906 812790 814239 815019 815524 816007 816949 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings teacher ffm"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел teacher жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел teacher жмж секс втро"
]
|
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.