SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003905s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49603 LIMIT 1 [ RunTime:0.003952s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49603 [ RunTime:0.003415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420147,503059,936693,810178,549670,1028615,45740,185452,426301,899777,58980,999368,789130,875032,362030,801908,558433,749265,120431,198704,194349,311281,603287,108249,118436,1004700,1014858,123557,669409,1043408,831940,246650,498884,265125,640662,429003,510788,749753,846662,654535,394716,62557,704000,275851,628972,994920,221629,542803,132018,473355,48676,744379,954427,10861,209934,428318,987278,805756,490315,326931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]