Query Metrics
7
Database Queries
7
Different statements
171.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.51 ms (84.97%) |
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 91248 185123 185708 185788 350700 381833 382292 383018 387652 389238 401457 401484 401500 405088 405125 412222 413247 413816 416699 416733 418360 419115 419794 424817 426820 426894 429333 434012 434328 434440 435407 436322 439130 439343 441616 441820 444458 447227 449508 454004 454368 454953 456048 457141 457292 460131 462907 464172 464964 467042 467057 468236 471681 475431 475729 478035 485046 488923 491058 496481 497635 499651 501799 504681 505142 507175 507497 510890 511933 515879 517344 519281 519609 525251 525856 526167 528094 533630 538365 540833 545327 551283 551287 551366 551407 554983 566671 570922 576280 577340 581257 584384 587879 588525 592815 595865 596618 598856 607232 610251 612968 617162 620850 630825 637037 643413 644453 644585 665645 669085 670146 708471 736852 754435 768260 781005 786508 810793 825704 ] |
||||||||||||||||||||||||||||||
|
16.15 ms (9.43%) |
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 825704 456048 468236 497635 511933 538365 551366 566671 570922 576280 577340 551283 584384 595865 598856 596618 418360 447227 387652 434328 441820 405088 429333 382292 426820 457141 525251 485046 517344 519281 526167 504681 515879 519609 471681 439130 551407 551287 588525 413247 434440 444458 475431 475729 462907 545327 554983 587879 630825 612968 644585 644453 185123 401457 426894 454368 488923 491058 501799 499651 510890 824629 670146 637037 736852 643413 381833 419794 540833 454953 460131 467057 478035 505142 525856 528094 467042 581257 617162 620850 810793 185708 350700 419115 434012 401484 405125 412222 464964 507497 496481 383018 185788 533630 781005 708471 607232 786508 416733 454004 592815 436322 464172 507175 389238 669085 754435 768260 665645 610251 441616 424817 449508 457292 401500 91248 439343 413816 416699 435407 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.57%) |
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 91248 185123 185708 185788 350700 381833 382292 383018 387652 389238 401457 401484 401500 405088 405125 412222 413247 413816 416699 416733 418360 419115 419794 424817 426820 426894 429333 434012 434328 434440 435407 436322 439130 439343 441616 441820 444458 447227 449508 454004 454368 454953 456048 457141 457292 460131 462907 464172 464964 467042 467057 468236 471681 475431 475729 478035 485046 488923 491058 496481 497635 499651 501799 504681 505142 507175 507497 510890 511933 515879 517344 519281 519609 525251 525856 526167 528094 533630 538365 540833 545327 551283 551287 551366 551407 554983 566671 570922 576280 577340 581257 584384 587879 588525 592815 595865 596618 598856 607232 610251 612968 617162 620850 630825 637037 643413 644453 644585 665645 669085 670146 708471 736852 754435 768260 781005 786508 810793 825704 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"oil girl"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"масл девушк"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.90%) |
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.