SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381183 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381183 [ RunTime:0.003233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8547,131090,850496,966287,716874,449073,960704,594702,5987,805981,536565,377833,156296,631622,954860,998840,735461,2548,172371,337578,334867,49309,78479,608609,761454,22793,417799,170426,624712,437997,361641,970296,656643,951322,440969,873725,212793,994629,54020,380604,882469,1013158,57184,630722,806640,251946,693971,656339,153302,821551,634186,156596,691069,763162,434193,581045,514664,977039,131874,1036278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001185s ]