SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804500 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804500 [ RunTime:0.005070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000333,635742,824164,95600,687414,1014160,809647,943132,733819,88419,12384,532243,583093,620109,170017,1008288,679212,871773,997121,125268,666092,510724,243852,439151,1008723,734507,49395,661554,598494,36251,937654,146506,884094,374768,243465,1037370,857012,414852,349164,339729,288460,196930,125992,1034063,422914,976499,1031309,257910,487600,232685,996151,776180,34771,651030,932549,488202,15732,495468,257224,269121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001067s ]