SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411738 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411738 [ RunTime:0.004457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591258,555045,70924,592678,707977,2377,962339,986418,992606,640614,610598,1031773,620348,126872,97872,823567,836678,1020428,409132,950323,177114,676006,886166,711968,199052,679508,772594,724727,214179,982385,648994,173085,501370,657961,335617,217441,902217,462820,618737,372444,21043,861633,568878,26297,185078,863574,678990,453792,85538,589706,256322,438019,1918,806923,35439,41324,129036,93500,667332,131896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]