SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20403 LIMIT 1 [ RunTime:0.000668s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20403 [ RunTime:0.002633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512678,600784,754857,801080,836442,81444,577367,901581,383979,458968,66300,87858,156477,992411,109803,153064,364551,487179,713875,681505,143938,404389,301215,910087,865260,91446,1014910,152813,600008,427215,558133,790793,462446,251456,364510,651712,439066,1046339,50392,777480,650061,464129,46725,605578,305867,902480,435974,515031,285272,79475,223185,345149,653497,544191,195635,16575,265445,86981,567730,707481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000895s ]