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` = 671580 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671580 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509982,885322,628797,362738,814836,1016116,677868,230999,725001,865509,425942,607077,554661,81238,269087,127805,646257,169564,756373,459089,221819,89863,260116,460558,206219,89618,606086,726448,537266,889219,447137,964658,25641,662631,416015,476574,976454,979397,948993,706308,460817,767856,159103,273425,176958,866065,584541,583527,159245,747864,569059,144183,252736,522716,661547,132198,204683,224295,327520,201202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]