SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517148 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517148 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222091,381597,591769,13890,921063,381071,1038034,412809,477813,429348,486228,1044673,295065,688443,954164,564031,324965,35265,313910,775701,969627,969458,340319,261433,629274,149914,49438,860618,721965,971903,991125,775772,846448,491229,219097,810439,584252,154568,183952,348268,291194,420625,232237,263816,506873,780579,198608,1002622,484182,191400,807973,711976,776720,721069,752177,721930,926448,227194,960328,1007414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]