SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504136 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504136 [ RunTime:0.002895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315192,916503,319290,983847,31837,675024,473166,110519,582221,1025647,734045,997424,675755,839008,525489,562158,217785,444489,242551,413684,948861,295301,329295,793692,523678,330054,35598,87538,598659,977853,182174,821641,861099,17294,192339,10877,903842,805889,46975,319136,324489,458838,449199,759568,649904,228758,167860,549864,85486,587888,742619,158734,792819,1033895,697611,958823,815595,870835,480037,128868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504136 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504136 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000785s ]