SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410703 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410703 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86229,312358,498091,680664,130598,745650,50704,130078,522862,555380,107617,584250,1018849,315424,888039,238264,149491,712492,153914,185743,923121,502408,967566,569116,257234,84302,923532,670440,808446,556276,747712,36033,589250,940667,781072,254906,288511,97099,10376,356316,192140,903727,945367,813602,701892,838207,32601,397501,508842,453282,618130,480247,9286,435829,773380,413856,660819,479373,586654,719825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]