SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028965 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028965 [ RunTime:0.002069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79736,107457,414331,540339,941321,1022041,440489,563435,956074,1018926,738911,737339,791065,279760,125858,884006,316378,940885,280805,126193,650404,476618,529975,591278,290104,308057,1045426,876053,211068,785116,538107,533719,250780,839379,716987,604141,177306,1019170,160874,857767,52792,774014,816694,687627,1020763,104754,458245,724526,60982,353091,193941,761914,750723,598663,815637,111212,1001846,783924,987243,497143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028965 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028965 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]