SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503712 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503712 [ RunTime:0.002550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704665,564894,656643,179424,313774,618338,602113,438973,52055,997571,664212,894624,11975,64513,712680,919455,735606,492908,297095,317589,907245,768137,490045,576468,128479,218660,896377,587150,890868,198958,590984,74061,115167,919206,318422,142061,674844,365725,103349,502513,962195,58557,28697,624162,646523,926844,259053,954396,1029849,728844,381192,889970,243230,309982,152725,856689,234661,356137,650668,294507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]