SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453668 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453668 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680949,668240,86284,813128,246714,192729,197152,70427,255099,647686,241863,971090,72032,845821,776291,158888,746270,70996,849183,57045,1041351,813114,61536,131391,818601,62840,99831,60186,643514,494078,247331,523959,201879,865654,245218,970367,185165,1030145,656820,584268,986600,497186,126324,367214,741520,787156,596108,909431,826047,631363,971506,255733,632281,838359,926447,252511,314065,475745,905983,557219) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]