SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004669s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034006 LIMIT 1 [ RunTime:0.001334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034006 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807602,598542,727234,915199,789247,708348,613954,919893,302107,226857,933934,862110,94184,1037274,186745,372199,330890,516355,859727,175497,537347,122857,110421,406273,142403,130357,283644,200434,347453,435043,57694,490314,403214,155348,471510,540645,304677,292524,930188,318126,241668,211288,552212,545562,535022,992982,1015604,735257,271347,577014,74230,500910,90458,1007361,986647,109259,742355,253905,141126,65202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]