SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44791 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44791 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5304,698620,61146,782049,827054,353973,563905,475446,276873,516462,1031535,380231,821973,807696,673895,769692,221464,481460,399600,428882,573398,537613,816990,918947,397788,328221,602426,749686,907872,440119,471561,237935,93808,211463,657523,547413,98106,635404,330038,698585,98884,64351,135714,63997,436451,613251,657513,573112,758701,584799,534613,652322,362635,859865,514030,122324,918837,601268,67337,825980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]