SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405294 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405294 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91932,734462,1003997,478390,982479,662364,419350,78222,772622,335743,14205,145072,36354,45612,465705,585481,907062,919554,996581,1034249,666670,975279,972382,885101,12344,565974,949758,489026,71838,347627,751684,700473,593703,771477,982803,431020,852291,358612,356745,566618,709381,65479,739719,964132,118394,743530,49690,207235,427699,305857,637114,311730,34959,496267,971875,995978,52853,885212,442049,796728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]