SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331232 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331232 [ RunTime:0.006953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607971,11137,806188,810257,265143,953140,1011180,739123,964336,1021218,1001721,449736,1003318,432453,870003,888140,263911,422890,137740,194825,16491,384837,432255,324981,94066,186294,6608,853890,849336,877035,470892,433033,129452,357801,233478,1015029,237112,478963,334542,767106,714746,155666,723628,597737,919039,1047749,1032803,764025,420327,171315,829054,1040316,1028250,62483,409006,304686,181184,148643,933277,1032167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331232 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331232 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]