SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391026 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391026 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151571,605762,351800,255730,367136,731574,943014,11665,278289,767011,867690,68699,897365,51743,82687,104834,554872,165128,784242,820803,928591,523885,37372,37840,461550,510676,341016,2018,750124,797739,723439,556266,129199,568098,816289,24335,370895,591602,1016027,551587,612844,638023,803089,977814,626376,877813,502967,571231,91078,40814,796579,797100,204288,98790,293679,509010,774168,167719,91404,19156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000761s ]