SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318288 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318288 [ RunTime:0.002869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135180,222143,892425,892093,79143,573875,265242,618356,151514,361862,161563,869277,505315,298574,631483,204591,944548,500960,831591,53515,919632,419548,638638,803663,123295,387062,242809,318950,791894,152497,350649,922037,555315,875757,513892,85278,161289,708262,509021,691393,156185,448352,971229,907923,859887,156088,721105,434023,329747,908345,688213,357792,834497,606661,835636,325650,306835,80018,630325,823815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003376s ]