SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532047 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532047 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (799681,625047,465305,459794,964246,870689,583018,199631,408797,779760,557484,442090,884863,554923,876021,737215,804632,499074,543965,382863,244597,31962,94766,708869,302180,80447,487292,710876,753980,511601,499630,27295,148207,144958,435127,46100,1003541,790388,217507,510015,787681,918652,834486,137511,911411,1017047,303157,493518,760721,295082,596506,146869,794647,289143,635249,96421,48357,582410,88386,782194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]