SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50340 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50340 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350406,88730,945535,1039467,335609,855255,413321,433766,945870,971977,177253,254352,135080,470160,714434,229746,586598,795016,421636,46324,530535,407390,951563,606908,987992,266357,196850,640144,486980,416604,205499,280630,903629,111852,21198,941760,545168,919797,154999,898527,526129,815740,603408,692547,20774,445073,674116,706791,727539,260193,218204,28291,234857,59184,168762,917453,911772,655536,700551,551535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001063s ]