SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428092 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428092 [ RunTime:0.002186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905866,94331,644385,570236,459460,634876,914110,648663,782916,67626,955570,1046155,384316,310503,61501,223025,789428,772385,63119,547714,480570,902420,24667,449284,150421,204151,12025,361378,886573,1015530,614299,978445,389242,532217,847613,1016053,643883,9866,619328,1046698,750347,730080,1035608,179549,46719,676434,176208,402996,55230,531098,522780,106794,157335,155305,355597,840962,804076,17016,909094,1015125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]