SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010196 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010196 [ RunTime:0.002222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925032,144442,625136,36491,729628,853698,763152,716497,765279,689300,739499,119858,335028,609955,870868,200068,818844,759132,297167,233809,317581,7027,387574,1027724,285433,460239,556481,736143,849401,1019848,583409,426318,144770,13497,131320,797476,739705,493719,739165,142858,843381,343185,184379,779604,183153,481548,448947,902189,971443,588212,352311,542303,388870,996080,911025,1036287,353933,829017,63539,930181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]