SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325046 LIMIT 1 [ RunTime:0.000564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325046 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436878,329997,69000,151423,721472,767526,833687,675280,61825,536008,111964,157805,422193,381866,402165,631555,919680,510639,777913,984362,438291,199196,1034018,994307,146458,498322,54465,523946,731667,632134,585899,141657,309756,573702,240522,844867,474198,183816,8983,183983,825872,415042,187701,237423,929701,645572,699013,214120,562529,314626,950812,217065,983863,524710,88911,342118,642812,649133,777380,1022220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002702s ]