SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335974 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335974 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118896,847975,433899,808625,507703,677947,438096,228377,1038849,24932,197455,383916,778151,484015,878502,814358,654977,934953,412200,364207,837964,269694,854903,928580,311684,416045,278979,409823,248046,593535,85989,758478,976280,160101,237650,308164,311799,305834,894034,575080,296269,773713,547815,426988,228633,300205,810732,914565,451289,442855,857517,127491,986525,821666,258679,1031816,890768,155013,239967,483899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]