SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568381 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568381 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (588049,823099,200502,773898,149282,371813,72848,150081,1044119,325486,160374,480599,196607,983992,822829,111516,259505,340441,969669,783315,204062,1045754,809453,797017,676918,391793,812998,626328,347798,597517,198777,99608,634951,380535,408005,32103,739297,557034,18299,170765,220738,532042,170489,636011,897513,537267,838515,303647,1029631,381703,804247,580823,467519,641111,815140,1422,275694,314514,893279,888725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]