SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002453s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983580 LIMIT 1 [ RunTime:0.001038s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983580 [ RunTime:0.007543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682366,143065,431663,106522,903767,362848,39907,483591,258948,683777,509650,698811,91967,935896,540503,101958,477236,999428,870009,318142,67821,449205,160718,368742,316328,38728,648438,606189,603076,604596,132394,966638,832070,545103,1029375,386874,250733,882634,536999,143394,258276,474262,470014,1001425,767854,391242,41649,33539,213365,1003183,652050,384096,562559,833065,522333,185529,12976,36048,318147,63061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]