SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460164 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460164 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72810,383701,398956,25550,841443,845069,409262,318929,311035,489620,705686,383089,397697,664031,535256,683105,111645,926937,840736,65235,614672,787273,380360,279595,372982,697020,1033399,11499,787455,284244,167277,215828,164386,171826,198047,846545,618988,143565,266342,71248,1046610,535228,901776,56255,1048010,29379,240775,631958,849819,964017,945078,868696,567058,1038165,371990,996049,1037349,292862,620533,774410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]