SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002619s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445430 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445430 [ RunTime:0.003531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800115,1004070,561842,736122,470089,49711,303017,461612,295451,880194,437181,550114,530305,57884,376965,446016,58200,410452,300861,197828,811077,128594,193016,215753,472291,1048860,92437,44928,659356,754090,16031,533696,438750,753473,274127,228285,208719,845469,426909,876870,289165,877999,441414,692738,862651,935074,1035873,770622,786859,385388,217358,376522,208072,880418,139781,948820,905913,986846,82731,917182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]