SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000905s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428017 LIMIT 1 [ RunTime:0.000746s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428017 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717333,139950,144113,91963,881957,823242,880946,468959,667896,384953,79009,473327,321702,818833,110559,407256,673186,340401,106556,184132,369884,856960,753862,614897,194524,339711,738407,395255,467009,282666,93499,738693,6129,33204,293242,794772,259720,859549,665284,327403,661598,776486,312094,884151,718218,398979,874053,55324,144175,907059,60753,477796,821718,153491,394242,900422,26923,436892,54772,801853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]