Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "step son wife"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'step son wife' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  403600
  435934
  443167
  434003
  532012
  509382
  516226
  519336
  537123
  544420
  549821
  563438
  568344
  582372
  561607
  549822
  549848
  577051
  596208
  600965
  591296
  437314
  437497
  437583
  503961
  506044
  516393
  520203
  538001
  538008
  538009
  535450
  549829
  520683
  565983
  462322
  519589
  434044
  449717
  454315
  539744
  535335
  515018
  541239
  549824
  621724
  424200
  444703
  504968
  400143
  529143
  518841
  453721
  460370
  518852
  557537
  535109
  549830
  523256
  549841
  623378
  618359
  445408
  547612
  601851
  482321
  620001
  614906
  621655
  563456
  563446
  484554
  464564
  563441
  512952
  519023
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (403600, 435934, 443167, 434003, 532012, 509382, 516226, 519336, 537123, 544420, 549821, 563438, 568344, 582372, 561607, 549822, 549848, 577051, 596208, 600965, 591296, 437314, 437497, 437583, 503961, 506044, 516393, 520203, 538001, 538008, 538009, 535450, 549829, 520683, 565983, 462322, 519589, 434044, 449717, 454315, 539744, 535335, 515018, 541239, 549824, 621724, 424200, 444703, 504968, 400143, 529143, 518841, 453721, 460370, 518852, 557537, 535109, 549830, 523256, 549841, 623378, 618359, 445408, 547612, 601851, 482321, 620001, 614906, 621655, 563456, 563446, 484554, 464564, 563441, 512952, 519023);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  400143
  403600
  424200
  434003
  434044
  435934
  437314
  437497
  437583
  443167
  444703
  445408
  449717
  453721
  454315
  460370
  462322
  464564
  482321
  484554
  503961
  504968
  506044
  509382
  512952
  515018
  516226
  516393
  518841
  518852
  519023
  519336
  519589
  520203
  520683
  523256
  529143
  532012
  535109
  535335
  535450
  537123
  538001
  538008
  538009
  539744
  541239
  544420
  547612
  549821
  549822
  549824
  549829
  549830
  549841
  549848
  557537
  561607
  563438
  563441
  563446
  563456
  565983
  568344
  577051
  582372
  591296
  596208
  600965
  601851
  614906
  618359
  620001
  621655
  621724
  623378
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (400143, 403600, 424200, 434003, 434044, 435934, 437314, 437497, 437583, 443167, 444703, 445408, 449717, 453721, 454315, 460370, 462322, 464564, 482321, 484554, 503961, 504968, 506044, 509382, 512952, 515018, 516226, 516393, 518841, 518852, 519023, 519336, 519589, 520203, 520683, 523256, 529143, 532012, 535109, 535335, 535450, 537123, 538001, 538008, 538009, 539744, 541239, 544420, 547612, 549821, 549822, 549824, 549829, 549830, 549841, 549848, 557537, 561607, 563438, 563441, 563446, 563456, 565983, 568344, 577051, 582372, 591296, 596208, 600965, 601851, 614906, 618359, 620001, 621655, 621724, 623378);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  400143
  403600
  424200
  434003
  434044
  435934
  437314
  437497
  437583
  443167
  444703
  445408
  449717
  453721
  454315
  460370
  462322
  464564
  482321
  484554
  503961
  504968
  506044
  509382
  512952
  515018
  516226
  516393
  518841
  518852
  519023
  519336
  519589
  520203
  520683
  523256
  529143
  532012
  535109
  535335
  535450
  537123
  538001
  538008
  538009
  539744
  541239
  544420
  547612
  549821
  549822
  549824
  549829
  549830
  549841
  549848
  557537
  561607
  563438
  563441
  563446
  563456
  565983
  568344
  577051
  582372
  591296
  596208
  600965
  601851
  614906
  618359
  620001
  621655
  621724
  623378
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (400143, 403600, 424200, 434003, 434044, 435934, 437314, 437497, 437583, 443167, 444703, 445408, 449717, 453721, 454315, 460370, 462322, 464564, 482321, 484554, 503961, 504968, 506044, 509382, 512952, 515018, 516226, 516393, 518841, 518852, 519023, 519336, 519589, 520203, 520683, 523256, 529143, 532012, 535109, 535335, 535450, 537123, 538001, 538008, 538009, 539744, 541239, 544420, 547612, 549821, 549822, 549824, 549829, 549830, 549841, 549848, 557537, 561607, 563438, 563441, 563446, 563456, 565983, 568344, 577051, 582372, 591296, 596208, 600965, 601851, 614906, 618359, 620001, 621655, 621724, 623378);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "step son жен"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'step son жен';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "step son жен"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'step son жен';