Query Metrics
7
Database Queries
7
Different statements
288.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
262.67 ms (90.90%) |
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 187516 384124 385632 390642 391931 398968 414972 419016 425529 428955 435798 438209 438735 439362 441020 444195 453860 455375 461505 461560 461708 462172 463509 465798 470630 473313 473692 476788 477907 483853 484611 485298 489115 489377 492643 495800 496041 497192 498776 500825 501909 502201 504233 505462 507003 509088 511235 511665 513255 516242 522811 523848 526482 527349 543680 543704 544168 558504 559007 560345 566624 567402 570307 571721 574609 577968 581360 595479 600936 604121 609617 616992 654555 657572 662212 679266 679281 686331 689943 690663 690667 690726 700815 702319 707373 713817 713940 714911 718537 718669 721867 732087 732142 733958 743778 751138 755883 761022 763471 782131 782179 783363 783630 787716 788623 790580 791214 794082 794428 794455 797918 802091 803555 804306 810847 812287 812663 813702 818005 825741 ] |
||||||||||||||||||||||||||||||
|
15.47 ms (5.35%) |
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 473313 384124 398968 441020 455375 501909 511235 507003 523848 489115 461708 505462 444195 483853 463509 559007 567402 544168 566624 686331 713817 714911 718669 721867 558504 574609 616992 600936 609617 782179 787716 802091 763471 732142 761022 732087 804306 428955 438735 476788 465798 477907 414972 419016 425529 435798 439362 461505 504233 522811 495800 498776 489377 516242 527349 485298 513255 818005 813702 473692 560345 662212 702319 700815 679281 718537 803555 812287 733958 743778 755883 783363 797918 810847 788623 790580 794455 385632 453860 390642 543704 707373 571721 604121 782131 526482 825741 657572 470630 581360 570307 577968 654555 438209 462172 461560 187516 511665 484611 496041 502201 509088 492643 497192 391931 500825 543680 689943 690663 679266 690726 713940 690667 595479 791214 794428 812663 751138 783630 794082 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (0.92%) |
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 187516 384124 385632 390642 391931 398968 414972 419016 425529 428955 435798 438209 438735 439362 441020 444195 453860 455375 461505 461560 461708 462172 463509 465798 470630 473313 473692 476788 477907 483853 484611 485298 489115 489377 492643 495800 496041 497192 498776 500825 501909 502201 504233 505462 507003 509088 511235 511665 513255 516242 522811 523848 526482 527349 543680 543704 544168 558504 559007 560345 566624 567402 570307 571721 574609 577968 581360 595479 600936 604121 609617 616992 654555 657572 662212 679266 679281 686331 689943 690663 690667 690726 700815 702319 707373 713817 713940 714911 718537 718669 721867 732087 732142 733958 743778 751138 755883 761022 763471 782131 782179 783363 783630 787716 788623 790580 791214 794082 794428 794455 797918 802091 803555 804306 810847 812287 812663 813702 818005 825741 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск ван"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian bathroom"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.66%) |
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.