SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531566 LIMIT 1 [ RunTime:0.001248s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531566 [ RunTime:0.003698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100037,514605,318538,976868,564286,1024438,526053,979914,311973,588221,1023981,823516,491376,1027450,112925,683159,595348,23586,460748,468847,983043,456220,766126,405545,295107,394939,489796,362755,342496,675530,20474,347386,902222,784399,326980,811117,573673,112439,243708,619756,765627,953201,694916,208222,361325,802331,463792,314665,480691,323266,100603,513551,149528,962802,893172,623222,61724,323771,21022,910194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.015354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005918s ]