SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033501 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033501 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367943,122560,381718,594929,102276,175812,610665,474433,833666,115292,28180,962465,439578,272889,952065,1034500,45926,279878,962897,131619,617881,105232,520630,391800,274789,275527,654646,973206,679865,689493,764148,19074,265406,523827,582308,236187,521928,915407,954045,432603,711640,127351,228224,928802,827376,413656,243674,405890,594009,818051,547738,303605,828927,148818,574237,21842,37049,476146,594660,213785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]