SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50448 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50448 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383150,372758,79304,570165,990535,569629,723701,173843,997051,157936,968211,56738,942348,33388,411076,644185,435732,246568,294987,791969,480169,480524,885598,841711,942447,877709,558501,923274,851804,434387,747702,978384,119067,705488,757490,282055,954863,442581,258101,1028018,62433,519910,705972,645485,815143,337458,721903,403971,78396,277886,1026726,331191,274077,637625,781941,433306,392042,263038,980140,449696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]