SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419945 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419945 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4640,355493,64211,567769,490126,530753,479179,906257,972951,377779,496703,396998,32030,999991,689597,60527,965884,547026,544422,371817,530149,845356,620462,585576,457173,37004,335264,134106,835170,1046048,628288,516848,958347,297916,491071,988816,410812,906063,259817,929451,1003496,272461,198078,151032,204663,740510,48423,791102,792935,709179,695513,734433,50236,406135,292884,774315,642314,1008967,150476,38108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]