Query Metrics
7
Database Queries
7
Different statements
139.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.45 ms (83.94%) |
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 381803 383911 391697 395395 395567 396704 396772 397200 398799 401359 403210 406931 407177 415256 418360 418405 423033 424622 428539 428931 429426 437710 437730 438714 439130 443867 445013 445986 447329 447629 448095 448760 449744 450256 454272 454742 462939 464600 466443 467173 469248 469773 470404 470764 474613 475740 476834 477693 478885 479248 479281 479531 483842 484400 485196 487680 487824 490000 491656 492043 493849 494942 495358 495549 496959 497130 498865 499741 500151 501452 501615 502082 504233 505865 506154 506268 508064 509358 510467 510689 511224 511982 513700 514802 516161 518321 519762 521323 523709 523984 525758 543835 546006 546977 550236 551256 551597 551604 551614 558658 560477 562248 566451 567701 570295 571865 575789 579202 581649 584527 587885 588674 590554 602651 605050 637049 651589 659042 770264 ] |
||||||||||||||||||||||||||||||
|
13.59 ms (9.71%) |
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 397200 401359 443867 450256 462939 469773 478885 391697 395395 396704 406931 418405 429426 437710 449744 464600 470764 479281 504233 508064 509358 511982 490000 494942 506268 521323 485196 487680 497130 510467 523984 484400 491656 492043 499741 519762 523709 476834 403210 447629 551256 651589 495549 469248 479531 502082 505865 501615 566451 551597 551604 560477 570295 575789 584527 546006 571865 579202 587885 605050 590554 602651 418360 438714 437730 454272 447329 479248 477693 511224 518321 483842 506154 495358 513700 500151 501452 381803 562248 395567 496959 543835 448095 448760 428539 470404 546977 558658 551614 567701 659042 475740 516161 498865 637049 823743 398799 428931 423033 424622 588674 454742 415256 525758 407177 445986 474613 550236 581649 770264 467173 439130 466443 445013 510689 493849 487824 514802 383911 396772 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (2.08%) |
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 381803 383911 391697 395395 395567 396704 396772 397200 398799 401359 403210 406931 407177 415256 418360 418405 423033 424622 428539 428931 429426 437710 437730 438714 439130 443867 445013 445986 447329 447629 448095 448760 449744 450256 454272 454742 462939 464600 466443 467173 469248 469773 470404 470764 474613 475740 476834 477693 478885 479248 479281 479531 483842 484400 485196 487680 487824 490000 491656 492043 493849 494942 495358 495549 496959 497130 498865 499741 500151 501452 501615 502082 504233 505865 506154 506268 508064 509358 510467 510689 511224 511982 513700 514802 516161 518321 519762 521323 523709 523984 525758 543835 546006 546977 550236 551256 551597 551604 551614 558658 560477 562248 566451 567701 570295 571865 575789 579202 581649 584527 587885 588674 590554 602651 605050 637049 651589 659042 770264 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny bitch"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.19 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.