Zend Framework 2 2.2.2
New Version 2.4.9 Documentation Modules Gallery Version 2.2.2 PHP Version 5.3.29 Extensions intl ModulesZendDeveloperToolsZfcBaseZfcUserZfcTwitterBootstrapApplicationIlustratumEdpModuleLayoutsBoxSliderPageMenuPostGalleryFileSetting
Request and Response 200 Index::renderPage on content
Status code 200 Method GET Controller Application\Controller\Index Action renderPage Route content Templateslayout/portalview/home.phtml
Execution Time 174.07 ms
Total Time 174.07 ms
Memory Peak 5.50 Mb
Memory Peak 5.50 Mb
Config Config
Merged Config (Config)
array(10) {
  ["view_manager"] => array(7) {
    ["template_path_stack"] => array(11) {
      ["zenddevelopertools"] => string(78) "/customers/50partners/vendor/zendframework/zend-developer-tools/config/../view"
      ["zfcuser"] => string(63) "/customers/50partners/vendor/zf-commons/zfc-user/config/../view"
      [0] => string(55) "/customers/50partners/module/Application/config/../view"
      ["box"] => string(47) "/customers/50partners/module/Box/config/../view"
      ["slider"] => string(50) "/customers/50partners/module/Slider/config/../view"
      ["page"] => string(48) "/customers/50partners/module/Page/config/../view"
      ["menu"] => string(48) "/customers/50partners/module/Menu/config/../view"
      ["post"] => string(48) "/customers/50partners/module/Post/config/../view"
      ["gallery"] => string(51) "/customers/50partners/module/Gallery/config/../view"
      ["file"] => string(48) "/customers/50partners/module/File/config/../view"
      ["setting"] => string(51) "/customers/50partners/module/Setting/config/../view"
    }
    ["display_not_found_reason"] => bool(true)
    ["display_exceptions"] => bool(true)
    ["doctype"] => string(5) "HTML5"
    ["not_found_template"] => string(9) "error/404"
    ["exception_template"] => string(11) "error/index"
    ["template_map"] => array(4) {
      ["layout/layout"] => string(75) "/customers/50partners/module/Application/config/../view/layout/layout.phtml"
      ["application/index/index"] => string(85) "/customers/50partners/module/Application/config/../view/application/index/index.phtml"
      ["error/404"] => string(71) "/customers/50partners/module/Application/config/../view/error/404.phtml"
      ["error/index"] => string(73) "/customers/50partners/module/Application/config/../view/error/index.phtml"
    }
  }
  ["controllers"] => array(1) {
    ["invokables"] => array(2) {
      ["zfcuser"] => string(33) "ZfcUser\Controller\UserController"
      ["Application\Controller\Index"] => string(38) "Application\Controller\IndexController"
    }
  }
  ["service_manager"] => array(3) {
    ["aliases"] => array(2) {
      ["zfcuser_zend_db_adapter"] => string(23) "Zend\Db\Adapter\Adapter"
      ["db_adapter"] => string(23) "Zend\Db\Adapter\Adapter"
    }
    ["factories"] => array(2) {
      ["translator"] => string(45) "Zend\I18n\Translator\TranslatorServiceFactory"
      ["Zend\Db\Adapter\Adapter"] => object(Closure)#599 (0) {
      }
    }
    ["services"] => array(4) {
      ["session"] => array(1) {
        ["lang"] => string(5) "en_US"
      }
      ["languages"] => array(1) {
        ["en_US"] => string(7) "English"
      }
      ["business_sectores"] => array(7) {
        [1] => string(18) "ENERGY & UTILITIES"
        [2] => string(28) "CONSUMER PRODUCTS & SERVICES"
        [3] => string(26) "INDUSTRIAL & MANUFACTURING"
        [4] => string(27) "TECHNOLOGY & COMMUNICATIONS"
        [5] => string(23) "HUMAN RESOURCES & LEGAL"
        [6] => string(18) "FINANCIAL SERVICES"
        [7] => string(24) "LIFESCIENCE & HEALTHCARE"
      }
      ["templates_path"] => string(51) "/customers/50partners/module/Application/view/view/"
    }
  }
  ["router"] => array(1) {
    ["routes"] => array(19) {
      ["zfcuser"] => array(5) {
        ["type"] => string(7) "Literal"
        ["priority"] => int(1000)
        ["options"] => array(2) {
          ["route"] => string(5) "/user"
          ["defaults"] => array(2) {
            ["controller"] => string(7) "zfcuser"
            ["action"] => string(5) "index"
          }
        }
        ["may_terminate"] => bool(true)
        ["child_routes"] => array(6) {
          ["login"] => array(2) {
            ["type"] => string(7) "Literal"
            ["options"] => array(2) {
              ["route"] => string(6) "/login"
              ["defaults"] => array(2) {
                ["controller"] => string(7) "zfcuser"
                ["action"] => string(5) "login"
              }
            }
          }
          ["authenticate"] => array(2) {
            ["type"] => string(7) "Literal"
            ["options"] => array(2) {
              ["route"] => string(13) "/authenticate"
              ["defaults"] => array(2) {
                ["controller"] => string(7) "zfcuser"
                ["action"] => string(12) "authenticate"
              }
            }
          }
          ["logout"] => array(2) {
            ["type"] => string(7) "Literal"
            ["options"] => array(2) {
              ["route"] => string(7) "/logout"
              ["defaults"] => array(2) {
                ["controller"] => string(7) "zfcuser"
                ["action"] => string(6) "logout"
              }
            }
          }
          ["register"] => array(2) {
            ["type"] => string(7) "Literal"
            ["options"] => array(2) {
              ["route"] => string(9) "/register"
              ["defaults"] => array(2) {
                ["controller"] => string(7) "zfcuser"
                ["action"] => string(8) "register"
              }
            }
          }
          ["changepassword"] => array(2) {
            ["type"] => string(7) "Literal"
            ["options"] => array(2) {
              ["route"] => string(16) "/change-password"
              ["defaults"] => array(2) {
                ["controller"] => string(7) "zfcuser"
                ["action"] => string(14) "changepassword"
              }
            }
          }
          ["changeemail"] => array(2) {
            ["type"] => string(7) "Literal"
            ["options"] => array(2) {
              ["route"] => string(13) "/change-email"
              ["defaults"] => array(2) {
                ["controller"] => string(7) "zfcuser"
                ["action"] => string(11) "changeemail"
              }
            }
          }
        }
      }
      ["content"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(19) "/[:alias][/:param1]"
          ["constraints"] => array(1) {
            ["alias"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
          }
          ["defaults"] => array(3) {
            ["__NAMESPACE__"] => string(22) "Application\Controller"
            ["controller"] => string(5) "Index"
            ["action"] => string(10) "renderPage"
          }
        }
      }
      ["job_offers_show"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(31) "/job-offers/show/:show_offer_id"
          ["constraints"] => array(1) {
            ["show_offer_id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(4) {
            ["__NAMESPACE__"] => string(22) "Application\Controller"
            ["controller"] => string(5) "Index"
            ["action"] => string(10) "renderPage"
            ["alias"] => string(10) "job-offers"
          }
        }
      }
      ["home"] => array(2) {
        ["type"] => string(28) "Zend\Mvc\Router\Http\Literal"
        ["options"] => array(2) {
          ["route"] => string(1) "/"
          ["defaults"] => array(3) {
            ["__NAMESPACE__"] => string(22) "Application\Controller"
            ["controller"] => string(5) "Index"
            ["action"] => string(5) "index"
          }
        }
      }
      ["admin"] => array(2) {
        ["type"] => string(7) "Literal"
        ["options"] => array(2) {
          ["route"] => string(7) "/admin/"
          ["defaults"] => array(3) {
            ["__NAMESPACE__"] => string(22) "Application\Controller"
            ["controller"] => string(5) "Index"
            ["action"] => string(9) "dashboard"
          }
        }
      }
      ["dashboard"] => array(2) {
        ["type"] => string(7) "Literal"
        ["options"] => array(2) {
          ["route"] => string(16) "/admin/dashboard"
          ["defaults"] => array(3) {
            ["__NAMESPACE__"] => string(22) "Application\Controller"
            ["controller"] => string(5) "Index"
            ["action"] => string(9) "dashboard"
          }
        }
      }
      ["application"] => array(4) {
        ["type"] => string(7) "Literal"
        ["options"] => array(2) {
          ["route"] => string(12) "/application"
          ["defaults"] => array(3) {
            ["__NAMESPACE__"] => string(22) "Application\Controller"
            ["controller"] => string(5) "Index"
            ["action"] => string(5) "index"
          }
        }
        ["may_terminate"] => bool(true)
        ["child_routes"] => array(1) {
          ["default"] => array(2) {
            ["type"] => string(7) "Segment"
            ["options"] => array(3) {
              ["route"] => string(23) "[:controller[/:action]]"
              ["constraints"] => array(2) {
                ["controller"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
                ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
              }
              ["defaults"] => array(0) {
              }
            }
          }
        }
      }
      ["change_language"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(35) "/application/changeLanguage[/:lang]"
          ["constraints"] => array(1) {
            ["id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(3) {
            ["__NAMESPACE__"] => string(22) "Application\Controller"
            ["controller"] => string(5) "Index"
            ["action"] => string(14) "changeLanguage"
          }
        }
      }
      ["get_job"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(25) "/application/getJob[/:id]"
          ["constraints"] => array(1) {
            ["id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(3) {
            ["__NAMESPACE__"] => string(22) "Application\Controller"
            ["controller"] => string(5) "Index"
            ["action"] => string(6) "getJob"
          }
        }
      }
      ["box"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(26) "/admin/box[/:action][/:id]"
          ["constraints"] => array(2) {
            ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
            ["id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(2) {
            ["controller"] => string(18) "Box\Controller\Box"
            ["action"] => string(5) "index"
          }
        }
      }
      ["slider"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(29) "/admin/slider[/:action][/:id]"
          ["constraints"] => array(2) {
            ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
            ["id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(2) {
            ["controller"] => string(24) "Slider\Controller\Slider"
            ["action"] => string(5) "index"
          }
        }
      }
      ["slider-slide"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(57) "/admin/slider/edit/:slider_id/slide[/:action][/:slide_id]"
          ["constraints"] => array(3) {
            ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
            ["id"] => string(6) "[0-9]+"
            ["slide_id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(2) {
            ["controller"] => string(23) "Slider\Controller\Slide"
            ["action"] => string(5) "index"
          }
        }
      }
      ["page"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(27) "/admin/page[/:action][/:id]"
          ["constraints"] => array(2) {
            ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
            ["id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(2) {
            ["controller"] => string(20) "Page\Controller\Page"
            ["action"] => string(5) "index"
          }
        }
      }
      ["menu"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(27) "/admin/menu[/:action][/:id]"
          ["constraints"] => array(2) {
            ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
            ["id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(2) {
            ["controller"] => string(20) "Menu\Controller\Menu"
            ["action"] => string(5) "index"
          }
        }
      }
      ["post"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(27) "/admin/post[/:action][/:id]"
          ["constraints"] => array(2) {
            ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
            ["id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(2) {
            ["controller"] => string(20) "Post\Controller\Post"
            ["action"] => string(5) "index"
          }
        }
      }
      ["gallery"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(30) "/admin/gallery[/:action][/:id]"
          ["constraints"] => array(2) {
            ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
            ["id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(2) {
            ["controller"] => string(26) "Gallery\Controller\Gallery"
            ["action"] => string(5) "index"
          }
        }
      }
      ["picture"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(63) "/admin/gallery/edit/:gallery_id/picture[/:action][/:picture_id]"
          ["constraints"] => array(3) {
            ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
            ["id"] => string(6) "[0-9]+"
            ["picture_id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(2) {
            ["controller"] => string(26) "Gallery\Controller\Picture"
            ["action"] => string(5) "index"
          }
        }
      }
      ["file"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(27) "/admin/file[/:action][/:id]"
          ["constraints"] => array(2) {
            ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
            ["id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(2) {
            ["controller"] => string(20) "File\Controller\FIle"
            ["action"] => string(5) "index"
          }
        }
      }
      ["setting"] => array(2) {
        ["type"] => string(7) "segment"
        ["options"] => array(3) {
          ["route"] => string(30) "/admin/setting[/:action][/:id]"
          ["constraints"] => array(2) {
            ["action"] => string(22) "[a-zA-Z][a-zA-Z0-9_-]*"
            ["id"] => string(6) "[0-9]+"
          }
          ["defaults"] => array(2) {
            ["controller"] => string(26) "Setting\Controller\Setting"
            ["action"] => string(5) "index"
          }
        }
      }
    }
  }
  ["view_helpers"] => array(1) {
    ["invokables"] => array(13) {
      ["ztbalert"] => string(37) "ZfcTwitterBootstrap\View\Helper\Alert"
      ["ztbbadge"] => string(37) "ZfcTwitterBootstrap\View\Helper\Badge"
      ["ztbcloseicon"] => string(41) "ZfcTwitterBootstrap\View\Helper\CloseIcon"
      ["ztbflashmessenger"] => string(46) "ZfcTwitterBootstrap\View\Helper\FlashMessenger"
      ["ztbform"] => string(41) "ZfcTwitterBootstrap\Form\View\Helper\Form"
      ["ztbformdescription"] => string(52) "ZfcTwitterBootstrap\Form\View\Helper\FormDescription"
      ["ztbformelement"] => string(48) "ZfcTwitterBootstrap\Form\View\Helper\FormElement"
      ["ztbformrenderer"] => string(41) "ZfcTwitterBootstrap\Form\View\Helper\Form"
      ["ztbicon"] => string(36) "ZfcTwitterBootstrap\View\Helper\Icon"
      ["ztbimage"] => string(37) "ZfcTwitterBootstrap\View\Helper\Image"
      ["ztblabel"] => string(37) "ZfcTwitterBootstrap\View\Helper\Label"
      ["ztbnavigation"] => string(42) "ZfcTwitterBootstrap\View\Helper\Navigation"
      ["ztbwell"] => string(36) "ZfcTwitterBootstrap\View\Helper\Well"
    }
  }
  ["translator"] => array(1) {
    ["translation_file_patterns"] => array(9) {
      [0] => array(3) {
        ["type"] => string(8) "phpArray"
        ["base_dir"] => string(59) "/customers/50partners/module/Application/config/../language"
        ["pattern"] => string(6) "%s.php"
      }
      [1] => array(4) {
        ["type"] => string(8) "phpArray"
        ["base_dir"] => string(51) "/customers/50partners/module/Box/config/../language"
        ["pattern"] => string(6) "%s.php"
        ["text_domain"] => string(3) "Box"
      }
      [2] => array(4) {
        ["type"] => string(8) "phpArray"
        ["base_dir"] => string(54) "/customers/50partners/module/Slider/config/../language"
        ["pattern"] => string(6) "%s.php"
        ["text_domain"] => string(6) "Slider"
      }
      [3] => array(4) {
        ["type"] => string(8) "phpArray"
        ["base_dir"] => string(52) "/customers/50partners/module/Page/config/../language"
        ["pattern"] => string(6) "%s.php"
        ["text_domain"] => string(4) "Page"
      }
      [4] => array(4) {
        ["type"] => string(8) "phpArray"
        ["base_dir"] => string(52) "/customers/50partners/module/Menu/config/../language"
        ["pattern"] => string(6) "%s.php"
        ["text_domain"] => string(4) "Menu"
      }
      [5] => array(4) {
        ["type"] => string(8) "phpArray"
        ["base_dir"] => string(52) "/customers/50partners/module/Post/config/../language"
        ["pattern"] => string(6) "%s.php"
        ["text_domain"] => string(4) "Post"
      }
      [6] => array(4) {
        ["type"] => string(8) "phpArray"
        ["base_dir"] => string(55) "/customers/50partners/module/Gallery/config/../language"
        ["pattern"] => string(6) "%s.php"
        ["text_domain"] => string(7) "Gallery"
      }
      [7] => array(4) {
        ["type"] => string(8) "phpArray"
        ["base_dir"] => string(52) "/customers/50partners/module/File/config/../language"
        ["pattern"] => string(6) "%s.php"
        ["text_domain"] => string(4) "File"
      }
      [8] => array(4) {
        ["type"] => string(8) "phpArray"
        ["base_dir"] => string(55) "/customers/50partners/module/Setting/config/../language"
        ["pattern"] => string(6) "%s.php"
        ["text_domain"] => string(7) "Setting"
      }
    }
  }
  ["db"] => array(5) {
    ["driver"] => string(3) "Pdo"
    ["dsn"] => string(48) "mysql:dbname=13934411_50partners;host=localhost;"
    ["driver_options"] => array(2) {
      [1002] => string(16) "SET NAMES 'UTF8'"
      ["options"] => array(1) {
        ["buffer_results"] => bool(true)
      }
    }
    ["username"] => string(19) "13934411_50partners"
    ["password"] => string(12) "_df,2721!d6n"
  }
  ["phpSettings"] => array(2) {
    ["date.timezone"] => string(13) "Europe/Warsaw"
    ["mbstring.internal_encoding"] => string(5) "UTF-8"
  }
  ["zfcuser"] => array(3) {
    ["enable_registration"] => bool(false)
    ["auth_adapters"] => array(1) {
      [100] => string(33) "ZfcUser\Authentication\Adapter\Db"
    }
    ["login_redirect_route"] => string(4) "page"
  }
  ["zenddevelopertools"] => array(2) {
    ["profiler"] => array(6) {
      ["enabled"] => bool(true)
      ["strict"] => bool(false)
      ["flush_early"] => bool(false)
      ["cache_dir"] => string(10) "data/cache"
      ["matcher"] => array(0) {
      }
      ["collectors"] => array(0) {
      }
    }
    ["toolbar"] => array(5) {
      ["enabled"] => bool(true)
      ["auto_hide"] => bool(false)
      ["position"] => string(6) "bottom"
      ["version_check"] => bool(true)
      ["entries"] => array(0) {
      }
    }
  }
}
Application Config ApplicationConfig
Application Config (ApplicationConfig)
array(2) {
  ["modules"] => array(15) {
    [0] => string(18) "ZendDeveloperTools"
    [1] => string(7) "ZfcBase"
    [2] => string(7) "ZfcUser"
    [3] => string(19) "ZfcTwitterBootstrap"
    [4] => string(11) "Application"
    [5] => string(10) "Ilustratum"
    [6] => string(16) "EdpModuleLayouts"
    [7] => string(3) "Box"
    [8] => string(6) "Slider"
    [9] => string(4) "Page"
    [10] => string(4) "Menu"
    [11] => string(4) "Post"
    [12] => string(7) "Gallery"
    [13] => string(4) "File"
    [14] => string(7) "Setting"
  }
  ["module_listener_options"] => array(2) {
    ["config_glob_paths"] => array(1) {
      [0] => string(39) "config/autoload/{,*.}{global,local}.php"
    }
    ["module_paths"] => array(2) {
      [0] => string(8) "./module"
      [1] => string(8) "./vendor"
    }
  }
}
Database (Zend\Db) 21 in 14.26 ms
Quantity create 0 read 21 update 0 delete 0 Time create 0 s read 14.26 ms update 0 s delete 0 s Query Profiles
SQL SELECT `setting`.* FROM `setting` Time 172.85 µs
SQL SELECT `menu`.* FROM `menu` WHERE `name` = :where1 AND `locale` = :where2 Params where1 => 'main-menu'
where2 => 'en_US'
Time 134.94 µs
SQL SELECT `page`.* FROM `page` WHERE `alias` = :where1 AND `locale` = :where2 Params where1 => 'home'
where2 => 'en_US'
Time 874.04 µs
SQL SELECT `slider`.* FROM `slider` WHERE `alias` = :where1 AND `locale` = :where2 Params where1 => 'our-fields-of-expertise'
where2 => 'en_US'
Time 809.91 µs
SQL SELECT `slider`.* FROM `slider` WHERE `alias` = :where1 AND `locale` = :where2 Params where1 => 'analyse-elaborate'
where2 => 'en_US'
Time 324.96 µs
SQL SELECT `slider`.* FROM `slider` WHERE `alias` = :where1 AND `locale` = :where2 Params where1 => 'our-team'
where2 => 'en_US'
Time 328.06 µs
SQL SELECT `box`.* FROM `box` WHERE `alias` = :where1 AND `locale` = :where2 Params where1 => 'home-customers-associates'
where2 => 'en_US'
Time 1.32 ms
SQL SELECT `post`.* FROM `post` WHERE `locale` = :where1 ORDER BY `publication_date` DESC LIMIT :limit Params where1 => 'en_US'
limit => 7
Time 1.29 ms
SQL SELECT `slide`.* FROM `slide` WHERE `slider_id` = :where1 ORDER BY `item_order` ASC Params where1 => '2'
Time 1.92 ms
SQL SELECT `slide`.* FROM `slide` WHERE `slider_id` = :where1 ORDER BY `item_order` ASC Params where1 => '2'
Time 237.94 µs
SQL SELECT `slide`.* FROM `slide` WHERE `slider_id` = :where1 ORDER BY `item_order` ASC Params where1 => '1'
Time 636.82 µs
SQL SELECT `slide`.* FROM `slide` WHERE `slider_id` = :where1 ORDER BY `item_order` ASC Params where1 => '4'
Time 889.78 µs
SQL SELECT `menu`.*, `p`.`title` AS `page_title`, `p`.`alias` AS `page_alias`, `m`.`name` AS `parent_name` FROM `menu` LEFT JOIN `page` AS `p` ON `p`.`id` = `menu`.`page_id` LEFT JOIN `menu` AS `m` ON `m`.`id` = `menu`.`parent_id` WHERE `menu`.`parent_id` = :where1 AND `menu`.`locale` = :where2 ORDER BY `menu`.`item_order` ASC Params where1 => '1'
where2 => 'en_US'
Time 818.97 µs
SQL SELECT `menu`.*, `p`.`title` AS `page_title`, `p`.`alias` AS `page_alias`, `m`.`name` AS `parent_name` FROM `menu` LEFT JOIN `page` AS `p` ON `p`.`id` = `menu`.`page_id` LEFT JOIN `menu` AS `m` ON `m`.`id` = `menu`.`parent_id` WHERE `menu`.`parent_id` = :where1 AND `menu`.`locale` = :where2 ORDER BY `menu`.`item_order` ASC Params where1 => '2'
where2 => 'en_US'
Time 530.96 µs
SQL SELECT `menu`.*, `p`.`title` AS `page_title`, `p`.`alias` AS `page_alias`, `m`.`name` AS `parent_name` FROM `menu` LEFT JOIN `page` AS `p` ON `p`.`id` = `menu`.`page_id` LEFT JOIN `menu` AS `m` ON `m`.`id` = `menu`.`parent_id` WHERE `menu`.`parent_id` = :where1 AND `menu`.`locale` = :where2 ORDER BY `menu`.`item_order` ASC Params where1 => '3'
where2 => 'en_US'
Time 738.86 µs
SQL SELECT `menu`.*, `p`.`title` AS `page_title`, `p`.`alias` AS `page_alias`, `m`.`name` AS `parent_name` FROM `menu` LEFT JOIN `page` AS `p` ON `p`.`id` = `menu`.`page_id` LEFT JOIN `menu` AS `m` ON `m`.`id` = `menu`.`parent_id` WHERE `menu`.`parent_id` = :where1 AND `menu`.`locale` = :where2 ORDER BY `menu`.`item_order` ASC Params where1 => '3'
where2 => 'en_US'
Time 130.18 µs
SQL SELECT `menu`.*, `p`.`title` AS `page_title`, `p`.`alias` AS `page_alias`, `m`.`name` AS `parent_name` FROM `menu` LEFT JOIN `page` AS `p` ON `p`.`id` = `menu`.`page_id` LEFT JOIN `menu` AS `m` ON `m`.`id` = `menu`.`parent_id` WHERE `menu`.`parent_id` = :where1 AND `menu`.`locale` = :where2 ORDER BY `menu`.`item_order` ASC Params where1 => '6'
where2 => 'en_US'
Time 618.93 µs
SQL SELECT `menu`.*, `p`.`title` AS `page_title`, `p`.`alias` AS `page_alias`, `m`.`name` AS `parent_name` FROM `menu` LEFT JOIN `page` AS `p` ON `p`.`id` = `menu`.`page_id` LEFT JOIN `menu` AS `m` ON `m`.`id` = `menu`.`parent_id` WHERE `menu`.`parent_id` = :where1 AND `menu`.`locale` = :where2 ORDER BY `menu`.`item_order` ASC Params where1 => '9'
where2 => 'en_US'
Time 618.93 µs
SQL SELECT `menu`.*, `p`.`title` AS `page_title`, `p`.`alias` AS `page_alias`, `m`.`name` AS `parent_name` FROM `menu` LEFT JOIN `page` AS `p` ON `p`.`id` = `menu`.`page_id` LEFT JOIN `menu` AS `m` ON `m`.`id` = `menu`.`parent_id` WHERE `menu`.`parent_id` = :where1 AND `menu`.`locale` = :where2 ORDER BY `menu`.`item_order` ASC Params where1 => '12'
where2 => 'en_US'
Time 608.21 µs
SQL SELECT `menu`.*, `p`.`title` AS `page_title`, `p`.`alias` AS `page_alias`, `m`.`name` AS `parent_name` FROM `menu` LEFT JOIN `page` AS `p` ON `p`.`id` = `menu`.`page_id` LEFT JOIN `menu` AS `m` ON `m`.`id` = `menu`.`parent_id` WHERE `menu`.`parent_id` = :where1 AND `menu`.`locale` = :where2 ORDER BY `menu`.`item_order` ASC Params where1 => '13'
where2 => 'en_US'
Time 644.21 µs
SQL SELECT `menu`.*, `p`.`title` AS `page_title`, `p`.`alias` AS `page_alias`, `m`.`name` AS `parent_name` FROM `menu` LEFT JOIN `page` AS `p` ON `p`.`id` = `menu`.`page_id` LEFT JOIN `menu` AS `m` ON `m`.`id` = `menu`.`parent_id` WHERE `menu`.`parent_id` = :where1 AND `menu`.`locale` = :where2 ORDER BY `menu`.`item_order` ASC Params where1 => '10'
where2 => 'en_US'
Time 609.16 µs