SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039335 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039335 [ RunTime:0.002444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127552,335477,788407,479250,338005,98249,610867,565526,628288,293062,614077,36704,383316,161725,249804,991407,130309,1031296,1004399,594565,55876,221919,111080,334535,42831,670057,5298,840292,717346,230974,935618,1351,811269,243998,793334,1009465,540192,685668,692834,616311,1016172,536035,678612,160278,139044,86193,376352,205118,697778,26967,699881,688448,272901,673338,875880,416892,284441,547479,258657,394820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000935s ]