SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408458 LIMIT 1 [ RunTime:0.000892s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408458 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212394,72615,28561,49603,764659,840976,777163,445509,893371,593524,1016508,849924,1016482,91673,885876,384282,470910,664675,452669,87826,492169,145356,767629,841061,758068,780123,862451,749845,161027,736628,222789,317885,603003,857426,455295,330639,786097,281112,923963,773439,217163,482472,598707,704595,751334,597812,125544,453995,526217,473033,1019362,605707,717939,47138,835306,1032482,845032,687764,73422,635160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000962s ]