SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901016 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901016 [ RunTime:0.002298s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905049,925221,171800,1041138,227743,282603,148200,587023,963200,478392,383578,363172,634912,941928,656449,964633,865527,788669,889427,433396,138783,603346,330853,690922,950175,177432,127334,442557,964060,522365,47616,544165,570780,253782,186934,527367,1010120,540951,1001587,369915,85912,478581,119877,583921,776428,896677,484432,379001,65863,375292,24545,519920,882019,660189,650916,318926,977442,460410,63427,686889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]