SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405699 LIMIT 1 [ RunTime:0.001646s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405699 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217918,1038939,741187,552801,691878,940446,299669,179045,457247,735798,788684,318036,911967,269554,408462,143640,490976,508933,205487,918582,26102,926061,907910,814238,526850,331713,287810,675338,216354,91846,784414,548483,12722,442167,348183,11183,992574,8004,787100,540417,648853,7795,510860,6955,136827,95907,724468,1021248,152440,378298,130875,254395,642269,1002588,631269,2098,610451,459370,721127,198699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003058s ]