SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481712 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481712 [ RunTime:0.002477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793139,241583,274730,856423,951082,610917,689231,480804,965249,597998,411980,946522,595510,297013,535984,22241,383026,690566,801521,814249,860201,83382,873419,112298,473531,16825,495193,829769,305039,602490,367015,875909,253575,314568,1039239,805199,20874,320098,614914,211699,318389,1011083,161486,177205,596188,526517,411144,793349,1021770,300976,436869,664044,589373,121657,451073,1001118,742072,172149,339061,782525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]