SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305176 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305176 [ RunTime:0.005285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661443,146335,1025073,962466,14247,598063,743059,432154,586989,123766,648457,426419,818680,17786,963959,773181,1046277,964766,66864,718417,123300,628974,501613,836775,568322,844798,794683,761903,680976,70527,905171,186275,904044,346502,707882,227957,982178,742660,726065,173735,128443,277842,650092,365512,338392,607878,288728,649112,962445,743829,905844,319441,51775,632311,1040240,96572,616121,207504,703573,827033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]