SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333896 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333896 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993046,419206,853367,126608,516384,905031,1004668,586738,1030485,699462,965332,604676,396103,557424,45422,140476,62270,265504,770962,569992,553710,94940,991183,63888,820977,366262,989120,514342,713984,830331,1041496,403497,796701,377964,141228,770824,171555,659806,431082,15824,747755,161671,137593,812736,124863,52527,154341,320776,798300,691525,939232,547272,28314,288746,361013,703213,527894,502935,770890,955024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000769s ]