SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280928 LIMIT 1 [ RunTime:0.001004s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280928 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505291,938373,963656,979283,30297,897970,818517,489923,981703,338883,378245,466443,23451,934869,739144,305976,534046,816608,1036934,453762,678318,364925,141952,919929,452378,596882,308644,361523,702938,461082,413475,125900,877204,676500,570979,218517,973521,712641,508586,385885,309378,1007822,118290,101442,187684,366289,476430,544997,29302,345546,129934,938062,624211,477568,89416,557960,888090,194924,839337,240677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030721s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001859s ]