SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476711 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476711 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63666,1045363,130308,345561,930925,506756,481366,870452,449310,949928,718761,999090,194376,806556,584993,110354,220357,1015935,659957,932458,676047,160332,256677,352522,890068,815093,71140,722403,864896,505409,872683,223602,730695,984916,900138,924526,1579,77431,25994,773222,416167,227869,767724,525372,704532,81115,678716,940517,684884,166611,123893,919237,552383,707046,814023,127423,750681,158231,881221,544395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]