SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687896 LIMIT 1 [ RunTime:0.000882s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687896 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734089,113641,910140,340502,512824,1038521,103280,930008,288174,378968,673260,204251,354596,969702,438876,716758,740192,984786,472296,299737,938890,728631,673479,101032,614543,641888,345423,601220,805586,84208,610982,1531,530136,397172,448670,705285,675823,47799,670699,254585,102969,262177,1030965,933390,968640,308750,393330,952530,894690,527567,39637,28488,440398,289136,915802,215908,878687,455608,417738,690373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001099s ]