About Social Lender
Navigation

Connect With Facebook Connect With Twitter


DB Profiling Summary Report (Query count: 45, Total query time: 0.11219s)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
SELECT * FROM `router` `t` WHERE domain = "dev.sociallender.co.za" LIMIT 1 9 0.01803 0.00200 0.00173 0.00285
INSERT INTO `yed_access_log` (`user_id`, `action`, `controller`, `data`) VALUES (:yp0, :yp1, :yp2, :yp3). Bound with :yp0=0, :yp1='article', :yp2='site', :yp3='{"method":"GET","id":"2"}' 1 0.01161 0.01161 0.01161 0.01161
SELECT * FROM `custom_table_menu_item` `t` WHERE menu_id = 2 AND (client_id LIKE '%"0"%' OR client_id LIKE '%"1"%') ORDER BY sort_order ASC 3 0.00725 0.00242 0.00232 0.00251
SHOW FULL COLUMNS FROM `global_settings` 1 0.00622 0.00622 0.00622 0.00622
SELECT * FROM `client` `t` WHERE `t`.`id`=1 LIMIT 1 2 0.00435 0.00217 0.00215 0.00220
SHOW FULL COLUMNS FROM `static_page` 1 0.00333 0.00333 0.00333 0.00333
SELECT * FROM `global_settings` `t` WHERE client_id = 1 LIMIT 1 1 0.00296 0.00296 0.00296 0.00296
SHOW FULL COLUMNS FROM `yed_access_log` 1 0.00282 0.00282 0.00282 0.00282
SHOW CREATE TABLE `user` 1 0.00275 0.00275 0.00275 0.00275
SHOW FULL COLUMNS FROM `client` 1 0.00270 0.00270 0.00270 0.00270
SHOW FULL COLUMNS FROM `user` 1 0.00263 0.00263 0.00263 0.00263
SHOW FULL COLUMNS FROM `router` 1 0.00253 0.00253 0.00253 0.00253
SHOW FULL COLUMNS FROM `custom_table_menu_item` 1 0.00249 0.00249 0.00249 0.00249
SHOW FULL COLUMNS FROM `language` 1 0.00234 0.00234 0.00234 0.00234
SHOW FULL COLUMNS FROM `advert` 1 0.00231 0.00231 0.00231 0.00231
SELECT * FROM `place_holder` `t` WHERE static_page_id = 2 1 0.00225 0.00225 0.00225 0.00225
SHOW CREATE TABLE `global_settings` 1 0.00224 0.00224 0.00224 0.00224
SHOW CREATE TABLE `language` 1 0.00221 0.00221 0.00221 0.00221
SELECT * FROM `router` `t` WHERE is_live=1 AND active=1 1 0.00215 0.00215 0.00215 0.00215
SELECT * FROM `language` `t` WHERE tag = "facebook_twitter_button_label" LIMIT 1 1 0.00214 0.00214 0.00214 0.00214
SHOW FULL COLUMNS FROM `place_holder` 1 0.00213 0.00213 0.00213 0.00213
SELECT * FROM `language` `t` WHERE tag = "navigation_label" LIMIT 1 1 0.00211 0.00211 0.00211 0.00211
SELECT * FROM `user` `t` WHERE `t`.`id`=0 LIMIT 1 1 0.00206 0.00206 0.00206 0.00206
SELECT * FROM `language` `t` WHERE tag = "connect_twitter_button_label" LIMIT 1 1 0.00203 0.00203 0.00203 0.00203
SHOW CREATE TABLE `advert` 1 0.00197 0.00197 0.00197 0.00197
SHOW CREATE TABLE `router` 1 0.00197 0.00197 0.00197 0.00197
SHOW CREATE TABLE `static_page` 1 0.00197 0.00197 0.00197 0.00197
SELECT * FROM `language` `t` WHERE tag = "information_label" LIMIT 1 1 0.00194 0.00194 0.00194 0.00194
SELECT * FROM `static_page` `t` WHERE `t`.`id`=2 LIMIT 1 1 0.00194 0.00194 0.00194 0.00194
SHOW CREATE TABLE `client` 1 0.00194 0.00194 0.00194 0.00194
SHOW CREATE TABLE `yed_access_log` 1 0.00191 0.00191 0.00191 0.00191
SELECT * FROM `advert` `t` WHERE client_id = 1 AND publish =1 ORDER BY date_time DESC LIMIT 5 1 0.00173 0.00173 0.00173 0.00173
SHOW CREATE TABLE `custom_table_menu_item` 1 0.00167 0.00167 0.00167 0.00167
SHOW CREATE TABLE `place_holder` 1 0.00149 0.00149 0.00149 0.00149