Query Metrics
7
Database Queries
7
Different statements
214.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.94 ms (87.60%) |
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 78926 154844 383000 391873 397899 398552 401508 417829 419253 430526 442035 448651 473005 482132 486243 489230 495516 496150 500505 505451 514034 518641 524169 526122 531877 532659 534532 536399 542370 543669 544749 547856 550303 551057 551810 551813 563265 571136 576512 577210 583716 589042 607248 613032 626021 630670 653888 658784 661455 662022 663567 667981 673923 679445 680588 681804 685013 685819 687362 689525 692438 692450 692453 693755 693761 705119 708303 709546 710056 710096 713454 715176 717615 718327 720138 720139 720202 724109 724304 725309 726455 728956 731113 732666 742353 742363 742684 745896 745917 746235 747560 750154 754289 755370 755478 764071 764220 768670 769418 772714 783627 784038 784066 784120 784236 784324 788026 791101 792246 796204 798135 800958 809562 812561 814379 817240 818465 824498 826238 827484 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (7.11%) |
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 817240 514034 495516 505451 532659 576512 661455 663567 784236 725309 755478 764220 812561 742353 764071 783627 784066 784120 401508 550303 542370 662022 680588 571136 720138 544749 526122 724304 524169 547856 720202 500505 551813 551057 796204 482132 713454 442035 826238 827484 818465 486243 563265 692438 692450 705119 679445 689525 717615 589042 724109 750154 769418 772714 784324 791101 742363 754289 768670 732666 715176 784038 809562 419253 489230 448651 154844 531877 583716 687362 692453 710096 667981 673923 728956 745896 742684 726455 745917 720139 473005 630670 417829 653888 693761 709546 681804 685819 607248 788026 746235 708303 536399 383000 430526 551810 792246 398552 496150 798135 397899 391873 577210 78926 824498 814379 534532 518641 543669 658784 685013 693755 710056 718327 613032 626021 800958 731113 747560 755370 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (1.55%) |
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 78926 154844 383000 391873 397899 398552 401508 417829 419253 430526 442035 448651 473005 482132 486243 489230 495516 496150 500505 505451 514034 518641 524169 526122 531877 532659 534532 536399 542370 543669 544749 547856 550303 551057 551810 551813 563265 571136 576512 577210 583716 589042 607248 613032 626021 630670 653888 658784 661455 662022 663567 667981 673923 679445 680588 681804 685013 685819 687362 689525 692438 692450 692453 693755 693761 705119 708303 709546 710056 710096 713454 715176 717615 718327 720138 720139 720202 724109 724304 725309 726455 728956 731113 732666 742353 742363 742684 745896 745917 746235 747560 750154 754289 755370 755478 764071 764220 768670 769418 772714 783627 784038 784066 784120 784236 784324 788026 791101 792246 796204 798135 800958 809562 812561 814379 817240 818465 824498 826238 827484 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur wife double"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск жен double"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск жен double"
]
|
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.