SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19482 LIMIT 1 [ RunTime:0.003414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19482 [ RunTime:0.003899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181155,61737,838886,765981,722989,576762,361113,352813,1027710,552305,102813,149619,102767,678156,338042,300859,130221,44097,924004,451738,825504,1008657,281284,374308,1016219,1021401,267465,424525,64092,623525,153428,62055,535860,90183,742985,400820,1017125,703016,916855,920054,340379,581593,201660,398078,168385,726629,291298,831709,631821,284218,171201,809618,154485,180112,660475,438576,573544,540937,990226,688024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]