SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445001 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445001 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843805,395503,445618,975324,345601,282529,733969,369265,844195,909650,992845,843806,925224,888618,44397,59072,1019946,785866,1036018,320173,139301,764543,626012,786721,488434,690300,218339,375049,540205,229578,163801,501947,430193,154190,772784,201076,630794,771294,913218,730137,369626,566950,474002,100153,638646,821563,959264,669891,449537,1029297,593087,994941,694275,118300,658787,564760,806666,968127,887981,857295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]