Query Metrics
7
Database Queries
7
Different statements
223.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.87 ms (87.70%) |
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 382438 393862 401275 403434 411910 424830 426153 426809 428373 437790 437997 439617 440571 442634 449096 449344 449603 450787 451304 453835 455875 456507 460512 465630 465926 466027 466797 471306 471332 471960 473250 474957 478307 479343 479960 487806 489259 494095 499371 501682 503739 505077 505225 505304 505795 506200 507285 507329 507812 509084 509330 511099 516653 516952 518607 519576 520014 520304 522735 525027 525264 525709 526200 526810 527955 528351 533125 534463 534603 535080 541379 542079 545852 549155 552332 552795 553247 553332 555090 556330 556492 557034 557740 558639 559502 563555 565859 565862 567091 567893 568742 571254 578611 580401 581754 582380 584690 587890 588767 588946 590493 592921 603967 604856 605794 614036 615818 618471 624320 624762 626352 630544 632562 651561 664777 670430 678015 679166 687433 723287 ] |
||||||||||||||||||||||||||||||
|
17.23 ms (7.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 503739 590493 519576 520014 584690 525264 624762 428373 426809 499371 516653 525709 526200 507329 474957 487806 567893 553247 568742 678015 687433 664777 557034 592921 587890 603967 618471 604856 624320 382438 426153 393862 437997 440571 465926 473250 439617 479960 451304 479343 449603 518607 522735 505225 507812 527955 506200 520304 505077 615818 505795 507285 541379 501682 552795 555090 556330 558639 565862 651561 605794 614036 455875 478307 509330 511099 401275 403434 411910 424830 442634 437790 449344 453835 465630 449096 450787 456507 466797 471306 471332 471960 466027 534603 494095 509084 534463 535080 505304 516952 525027 526810 528351 533125 460512 489259 542079 571254 581754 552332 553332 567091 582380 556492 557740 563555 580401 679166 670430 723287 545852 549155 559502 565859 578611 588767 588946 626352 630544 632562 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.50%) |
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 382438 393862 401275 403434 411910 424830 426153 426809 428373 437790 437997 439617 440571 442634 449096 449344 449603 450787 451304 453835 455875 456507 460512 465630 465926 466027 466797 471306 471332 471960 473250 474957 478307 479343 479960 487806 489259 494095 499371 501682 503739 505077 505225 505304 505795 506200 507285 507329 507812 509084 509330 511099 516653 516952 518607 519576 520014 520304 522735 525027 525264 525709 526200 526810 527955 528351 533125 534463 534603 535080 541379 542079 545852 549155 552332 552795 553247 553332 555090 556330 556492 557034 557740 558639 559502 563555 565859 565862 567091 567893 568742 571254 578611 580401 581754 582380 584690 587890 588767 588946 590493 592921 603967 604856 605794 614036 615818 618471 624320 624762 626352 630544 632562 651561 664777 670430 678015 679166 687433 723287 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public cum mouth"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на cum улиц mouth"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на cum улиц mouth"
]
|
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.