SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490991 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490991 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455543,378936,1539,966720,518588,378958,395338,741507,599914,483528,371867,440835,62477,852658,336227,279332,413182,608754,470044,813866,476543,1002219,451158,222129,628292,581165,115256,136189,464525,18105,226087,156255,200330,870493,943699,975898,837444,409480,149539,718253,841801,322969,514863,624267,203992,516617,427529,802656,576250,92687,687349,823361,900412,535545,111188,510335,951206,186372,872053,51204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001369s ]