SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414157 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414157 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504979,337391,1047734,220029,481589,313711,672070,447399,174914,799802,650439,344837,940828,856762,235536,374373,678764,733099,242923,374005,750812,391337,883311,223050,7226,163675,981170,452483,541074,150394,830694,828776,1009321,827609,593253,139,295901,672612,216551,183124,732834,1027394,890114,1040842,350102,832359,710197,345417,922125,389092,433087,647674,687947,1027390,1048134,430792,196420,179987,322241,677867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]