SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 47581 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 47581 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989031,648935,298891,102664,719081,1026228,91456,727237,444581,531640,265310,308474,300012,959346,811515,763439,512361,645663,423863,236273,543538,605379,692099,260026,699079,384170,613864,873635,13817,416674,951258,294871,632933,352327,216176,876041,200909,597,720905,750671,960608,914700,743402,62758,929411,427637,208569,851337,982428,264082,336539,502200,581980,763196,620078,852265,798704,753055,297754,179136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 47581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 47581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]