
09-03-2014, 06:56 PM
|
|
|
|
 Advanced Member
|
|
Join Date: Jun 2014
Posts: 86
|
|
|
Re: website slow
Hi x-cart team!
this is an report at file sql.log.2014.09.04
Quote:
[02:46:38.000000] Query #1: SELECT t0.moduleID AS moduleID1, t0.name AS name2, t0.author AS author3, t0.authorEmail AS authorEmail4, t0.enabled AS enabled5, t0.installed AS installed6, t0.yamlLoaded AS yamlLoaded7, t0.date AS date8, t0.rating AS rating9, t0.votes AS votes10, t0.downloads AS downloads11, t0.price AS price12, t0.currency AS currency13, t0.majorVersion AS majorVersion14, t0.minorVersion AS minorVersion15, t0.minorRequiredCoreVersion AS minorRequiredCoreVersion16, t0.revisionDate AS revisionDate17, t0.packSize AS packSize18, t0.xcnPlan AS xcnPlan19, t0.moduleName AS moduleName20, t0.authorName AS authorName21, t0.description AS description22, t0.iconURL AS iconURL23, t0.pageURL AS pageURL24, t0.authorPageURL AS authorPageURL25, t0.dependencies AS dependencies26, t0.tags AS tags27, t0.fromMarketplace AS fromMarketplace28, t0.isLanding AS isLanding29, t0.landingPosition AS landingPosition30, t0.isSystem AS isSystem31, t0.hasLicense AS hasLicense32, t0.editionState AS editionState33, t0.editions AS editions34 FROM xc_modules t0 WHERE t0.enabled = ?
Parameters:
true
Duration: 0.0005sec.
Doctrine UnitOfWork size: 365
Runtime id: 5585a5a267831563ff387eb03f19edb1
SAPI: cgi-fcgi; IP: 103.23.136.8
URI: /admin.php?target=module&moduleId=183
Method: GET
Backtrace:
file <X-Cart root>/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php : 717
file <X-Cart root>/lib/Doctrine/ORM/EntityRepository.php : 179
file <compiled classes repository>/classes/XLite/Model/Repo/Module.php : 738
file <compiled classes repository>/classes/XLite.php : 401
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 148
file <compiled classes repository>/classes/XLite/Controller/Admin/Module.php : 55
file <compiled classes repository>/classes/XLite.php : 417
file <compiled classes repository>/classes/XLite.php : 442
file <X-Cart root>/admin.php : 37
[02:46:38.000000] Query #2: SELECT t0.enabled AS enabled1, t0.id AS id2 FROM xc_roles t0 INNER JOIN xc_profile_roles ON t0.id = xc_profile_roles.role_id WHERE xc_profile_roles.profile_id = ?
Parameters:
4
Duration: 0.0033sec.
Doctrine UnitOfWork size: 377
Runtime id: 5585a5a267831563ff387eb03f19edb1
SAPI: cgi-fcgi; IP: 103.23.136.8
URI: /admin.php?target=module&moduleId=183
Method: GET
Backtrace:
file <X-Cart root>/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php : 862
file <X-Cart root>/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php : 801
file <X-Cart root>/lib/Doctrine/ORM/UnitOfWork.php : 2584
file <X-Cart root>/lib/Doctrine/ORM/PersistentCollection.php : 218
file <X-Cart root>/lib/Doctrine/ORM/PersistentCollection.php : 524
method Doctrine\ORM\PersistentCollection::count()
file <compiled classes repository>/classes/XLite/Model/Profile.php : 777
file <compiled classes repository>/classes/XLite/Core/Auth.php : 665
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 79
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 57
file <compiled classes repository>/classes/XLite/Controller/AControllerAbstract.php : 458
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 153
file <compiled classes repository>/classes/XLite/Controller/Admin/Module.php : 55
file <compiled classes repository>/classes/XLite.php : 417
file <compiled classes repository>/classes/XLite.php : 442
file <X-Cart root>/admin.php : 37
[02:46:38.000000] Query #3: SELECT t0.enabled AS enabled1, t0.id AS id2, t0.code AS code3, t0.section AS section4 FROM xc_permissions t0 INNER JOIN xc_role_permissions ON t0.id = xc_role_permissions.permission_id WHERE xc_role_permissions.role_id = ?
Parameters:
1
Duration: 0.0004sec.
Doctrine UnitOfWork size: 378
Runtime id: 5585a5a267831563ff387eb03f19edb1
SAPI: cgi-fcgi; IP: 103.23.136.8
URI: /admin.php?target=module&moduleId=183
Method: GET
Backtrace:
file <X-Cart root>/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php : 862
file <X-Cart root>/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php : 801
file <X-Cart root>/lib/Doctrine/ORM/UnitOfWork.php : 2584
file <X-Cart root>/lib/Doctrine/ORM/PersistentCollection.php : 218
file <X-Cart root>/lib/Doctrine/ORM/PersistentCollection.php : 568
file <compiled classes repository>/classes/XLite/Model/RoleAbstract.php : 107
file <compiled classes repository>/classes/XLite/Module/CDev/UserPermissions/Model/Role.php : 56
file <compiled classes repository>/classes/XLite/Model/Profile.php : 779
file <compiled classes repository>/classes/XLite/Core/Auth.php : 665
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 79
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 57
file <compiled classes repository>/classes/XLite/Controller/AControllerAbstract.php : 458
file <compiled classes repository>/classes/XLite/Controller/Admin/AAdmin.php : 153
file <compiled classes repository>/classes/XLite/Controller/Admin/Module.php : 55
file <compiled classes repository>/classes/XLite.php : 417
file <compiled classes repository>/classes/XLite.php : 442
file <X-Cart root>/admin.php : 37
|
|
|