SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510035 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510035 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523152,85713,438614,590514,549521,1005650,416280,670304,559085,865776,870940,339380,630523,137770,209713,966660,765351,480140,86695,914419,639807,639180,1017427,180348,674246,297516,282653,604090,37557,180904,434663,800332,249149,347680,45940,672879,916998,661090,313308,398389,188134,1018475,169984,844776,735214,272688,95439,763029,203079,601894,777623,66156,687070,799284,294145,191025,472011,978495,1013169,1004759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]