[ DB ] CONNECT:[ UseTime:0.000478s ] mysql:host=127.0.0.1;dbname=beijian_shop;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cascade` [ RunTime:0.000641s ]
[ SQL ] SELECT `id`,`name` FROM `cascade` WHERE ( pid = 13 and status = 1 ) ORDER BY `sort` ASC [ RunTime:0.000336s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.000502s ]
[ SQL ] SELECT `id`,`title`,`desc`,`coverimg`,`subject` FROM `product` WHERE `subject` IN (9,11,12,10) AND `status` = 1 AND `recommend` = 1 ORDER BY `levelsort` [ RunTime:0.000374s ]
[ SQL ] SHOW COLUMNS FROM `type` [ RunTime:0.000391s ]
[ SQL ] SELECT `id`,`name`,`pid` FROM `type` WHERE ( status = 1 ) [ RunTime:0.000222s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 11 and status = 1 ) LIMIT 1 [ RunTime:0.000208s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 11 and status = 1 ) LIMIT 1 [ RunTime:0.000179s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 12 and status = 1 ) LIMIT 1 [ RunTime:0.000208s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 12 and status = 1 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 13 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 13 and status = 1 ) LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 14 and status = 1 ) LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 14 and status = 1 ) LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 15 and status = 1 ) LIMIT 1 [ RunTime:0.000179s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 15 and status = 1 ) LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 16 and status = 1 ) LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 16 and status = 1 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 17 and status = 1 ) LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 17 and status = 1 ) LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 18 and status = 1 ) LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 18 and status = 1 ) LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 19 and status = 1 ) LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 19 and status = 1 ) LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 20 and status = 1 ) LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 20 and status = 1 ) LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 21 and status = 1 ) LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 21 and status = 1 ) LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 22 and status = 1 ) LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 22 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 23 and status = 1 ) LIMIT 1 [ RunTime:0.000177s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 23 and status = 1 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 24 and status = 1 ) LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 24 and status = 1 ) LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 25 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 25 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 26 and status = 1 ) LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 26 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 27 and status = 1 ) LIMIT 1 [ RunTime:0.000172s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 27 and status = 1 ) LIMIT 1 [ RunTime:0.000189s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 28 and status = 1 ) LIMIT 1 [ RunTime:0.000195s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 28 and status = 1 ) LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 29 and status = 1 ) LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 29 and status = 1 ) LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 30 and status = 1 ) LIMIT 1 [ RunTime:0.000206s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 30 and status = 1 ) LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 31 and status = 1 ) LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 31 and status = 1 ) LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 32 and status = 1 ) LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 32 and status = 1 ) LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 33 and status = 1 ) LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 33 and status = 1 ) LIMIT 1 [ RunTime:0.000176s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 34 and status = 1 ) LIMIT 1 [ RunTime:0.000193s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 34 and status = 1 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 44 and status = 1 ) LIMIT 1 [ RunTime:0.000205s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 44 and status = 1 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 45 and status = 1 ) LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 45 and status = 1 ) LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 46 and status = 1 ) LIMIT 1 [ RunTime:0.000176s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 46 and status = 1 ) LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 47 and status = 1 ) LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 47 and status = 1 ) LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 48 and status = 1 ) LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 48 and status = 1 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 49 and status = 1 ) LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 49 and status = 1 ) LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 50 and status = 1 ) LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 50 and status = 1 ) LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 51 and status = 1 ) LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 51 and status = 1 ) LIMIT 1 [ RunTime:0.000211s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 52 and status = 1 ) LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 52 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 53 and status = 1 ) LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 53 and status = 1 ) LIMIT 1 [ RunTime:0.000217s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 54 and status = 1 ) LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 54 and status = 1 ) LIMIT 1 [ RunTime:0.000213s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 55 and status = 1 ) LIMIT 1 [ RunTime:0.000204s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 55 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 56 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 56 and status = 1 ) LIMIT 1 [ RunTime:0.000213s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 57 and status = 1 ) LIMIT 1 [ RunTime:0.000195s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 57 and status = 1 ) LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 58 and status = 1 ) LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 58 and status = 1 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 59 and status = 1 ) LIMIT 1 [ RunTime:0.000215s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 59 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 60 and status = 1 ) LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 60 and status = 1 ) LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 61 and status = 1 ) LIMIT 1 [ RunTime:0.000196s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 61 and status = 1 ) LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 62 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 62 and status = 1 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 63 and status = 1 ) LIMIT 1 [ RunTime:0.000193s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 63 and status = 1 ) LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 64 and status = 1 ) LIMIT 1 [ RunTime:0.000180s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 64 and status = 1 ) LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 65 and status = 1 ) LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 65 and status = 1 ) LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 66 and status = 1 ) LIMIT 1 [ RunTime:0.000200s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 66 and status = 1 ) LIMIT 1 [ RunTime:0.000211s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 67 and status = 1 ) LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 67 and status = 1 ) LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 68 and status = 1 ) LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 68 and status = 1 ) LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 69 and status = 1 ) LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 69 and status = 1 ) LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 70 and status = 1 ) LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 70 and status = 1 ) LIMIT 1 [ RunTime:0.000189s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 71 and status = 1 ) LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 71 and status = 1 ) LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 72 and status = 1 ) LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 72 and status = 1 ) LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 73 and status = 1 ) LIMIT 1 [ RunTime:0.000192s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 73 and status = 1 ) LIMIT 1 [ RunTime:0.000232s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 74 and status = 1 ) LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 74 and status = 1 ) LIMIT 1 [ RunTime:0.000197s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 75 and status = 1 ) LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 75 and status = 1 ) LIMIT 1 [ RunTime:0.000210s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 76 and status = 1 ) LIMIT 1 [ RunTime:0.000191s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 76 and status = 1 ) LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 77 and status = 1 ) LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 77 and status = 1 ) LIMIT 1 [ RunTime:0.000195s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 78 and status = 1 ) LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 78 and status = 1 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 79 and status = 1 ) LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 79 and status = 1 ) LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 80 and status = 1 ) LIMIT 1 [ RunTime:0.000188s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 80 and status = 1 ) LIMIT 1 [ RunTime:0.000185s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 81 and status = 1 ) LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT `id`,`coverimg` FROM `product` WHERE ( type2 = 81 and status = 1 ) LIMIT 1 [ RunTime:0.000187s ]
