SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418016 LIMIT 1 [ RunTime:0.001676s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418016 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89143,916704,725755,627802,78342,304755,944061,473390,33271,794454,798751,28357,762363,441231,572229,693966,784910,507630,1043609,143294,1037954,706579,857848,154125,414369,351318,611266,318857,435064,30088,466880,595371,431770,1014757,366103,280524,748803,438739,261388,76312,560059,844002,91814,964783,229431,843871,445669,935676,65480,596282,904313,948466,737598,661076,298771,675724,123921,121210,786229,683994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]