SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 70442 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 70442 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431987,424925,1042042,652340,134082,197801,493444,518512,589347,540239,127669,336291,109145,638014,65108,331435,348804,757515,59329,544195,533548,816130,617050,613244,990755,288111,438406,115248,239248,413031,212986,254004,111528,995787,365400,500195,899403,90513,456519,116210,411468,180292,227443,338359,879160,637857,180937,123054,1030651,758772,444452,158343,912021,417508,871498,514947,778309,516913,288468,355934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 70442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 70442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]