SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101643 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101643 [ RunTime:0.002304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69237,848711,461051,131112,977701,150907,741243,275891,50910,646530,1029596,953637,1010850,138901,951667,189193,933398,605153,440831,716433,263616,474864,521137,878825,775391,437760,589969,27009,770680,278891,504844,468582,48141,707313,435695,58846,219546,824062,793199,907654,953557,560452,886144,834800,703117,891237,292312,714458,547723,750396,808160,899145,323447,282595,58252,67929,235741,441714,105274,420282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000769s ]