SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 179083 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 179083 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355815,345409,651674,317698,1035008,788044,144411,454947,319633,433356,578238,317318,201851,429162,861215,521971,287681,277521,324285,331398,554786,135967,927838,357375,295415,505839,514029,229829,1033332,1058,294789,472514,212995,932984,764555,727504,271289,482612,724879,381168,269136,38735,249948,493591,794074,229943,566556,549693,433561,975398,55790,295153,449530,195894,629630,828550,423296,397328,705231,157942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 179083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 179083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]