Query Metrics
7
Database Queries
7
Different statements
161.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.48 ms (83.88%) |
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 385748 387527 391227 395704 395839 396088 398029 398815 400843 403703 403761 415525 419269 420324 420400 421129 421807 436765 437402 444763 449280 452664 460076 461275 464225 465315 468398 470760 478734 480327 483480 484832 484841 484859 484872 487173 489990 490007 490008 490314 494096 504904 507875 512130 519110 521402 521939 521978 521996 522530 528052 544666 544725 544779 548619 548625 551478 551604 552738 553711 554333 554360 557996 559846 560411 562250 562259 563655 564145 567485 568757 575740 578367 578369 578371 578383 578385 583394 584685 589898 592304 594531 601218 612427 612715 615250 615466 620958 622716 626746 639853 641649 656497 659276 662438 675453 681714 690961 693500 695836 700849 709065 725594 732242 744615 748982 758335 765325 769143 785773 785820 788423 790719 796151 799292 801596 805254 805727 807495 826607 ] |
||||||||||||||||||||||||||||||
|
16.04 ms (9.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 521402 521939 484872 395839 449280 478734 528052 504904 544779 562259 568757 575740 578369 578371 553711 560411 681714 548625 594531 799292 748982 765325 805727 807495 391227 470760 480327 415525 490008 484841 484859 487173 521996 826607 583394 690961 709065 700849 675453 693500 592304 615466 796151 725594 732242 744615 790719 801596 398815 421807 461275 464225 490314 385748 387527 420324 452664 468398 522530 483480 551478 554360 584685 551604 562250 578367 578383 554333 557996 578385 695836 659276 662438 548619 559846 563655 564145 589898 612715 615250 620958 622716 626746 601218 641649 639853 805254 785773 785820 758335 788423 769143 403761 444763 396088 400843 403703 421129 437402 512130 521978 484832 489990 490007 395704 398029 420400 419269 436765 460076 465315 507875 494096 519110 544725 544666 552738 656497 567485 612427 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.87%) |
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 385748 387527 391227 395704 395839 396088 398029 398815 400843 403703 403761 415525 419269 420324 420400 421129 421807 436765 437402 444763 449280 452664 460076 461275 464225 465315 468398 470760 478734 480327 483480 484832 484841 484859 484872 487173 489990 490007 490008 490314 494096 504904 507875 512130 519110 521402 521939 521978 521996 522530 528052 544666 544725 544779 548619 548625 551478 551604 552738 553711 554333 554360 557996 559846 560411 562250 562259 563655 564145 567485 568757 575740 578367 578369 578371 578383 578385 583394 584685 589898 592304 594531 601218 612427 612715 615250 615466 620958 622716 626746 639853 641649 656497 659276 662438 675453 681714 690961 693500 695836 700849 709065 725594 732242 744615 748982 758335 765325 769143 785773 785820 788423 790719 796151 799292 801596 805254 805727 807495 826607 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"college девушк"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"college девушк"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"college girl"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.90%) |
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.