SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804487 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804487 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702398,200196,498127,896810,941344,548781,308507,944627,492859,325457,648120,784439,808901,873212,365376,749192,465291,352016,356560,1034083,774270,287607,416470,1039713,781965,818855,764594,278789,1028156,791456,844715,1000622,86673,984748,617913,790026,895500,3607,267243,516105,389279,267714,948006,660472,271222,456054,830920,207617,252560,748107,674240,351942,587162,380145,1036763,589781,654225,473711,1008390,915151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]