SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413808 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413808 [ RunTime:0.002959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110807,345744,811556,907010,32265,234415,359226,226855,430354,714790,954186,417529,688427,413630,506053,569613,298874,1047490,49554,450278,525452,927500,12793,846671,60803,785265,148741,396998,806258,347662,210410,228465,805667,781679,888765,866168,584718,573230,955086,448272,319787,481047,1047013,947872,145426,83853,128535,294187,404487,621684,666603,711177,301700,379927,921143,958630,255095,993028,1040727,438558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]