SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017513 LIMIT 1 [ RunTime:0.001363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017513 [ RunTime:0.004479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497275,759283,1014167,621849,182704,694508,28228,918774,555169,424749,920560,683159,518807,491338,677829,725024,778038,627981,207826,468903,775044,853250,381661,1037230,962990,615443,584494,254248,973239,588629,585091,343881,940310,9207,286966,956193,24583,496370,996772,447901,286418,32460,120694,684710,120559,600130,402375,511699,102926,441166,516156,662600,706571,584402,552300,47010,144988,19854,78548,84366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]