SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407905 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407905 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455526,700568,454396,909985,458797,959687,1002962,492218,442477,146105,252089,423171,670996,259882,269581,975467,932945,34418,814074,700615,373571,615408,671018,647103,696508,861822,184482,795295,664732,250019,148272,316572,105511,630805,634581,236495,864943,117013,257111,571627,258811,523104,105605,414170,181426,219202,71750,835528,759468,250388,1019354,570189,467336,613461,650239,678188,122997,699684,946602,27944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]